Mysql query help needed

I have two tables related by the column ID

I need to get all records from TABLEA and a count of related records for TABLE B IF ANY

This is what I have so far, but it only returns the records where there is a match on ID

select TableA.id,TableA.name, Count(TABLE B.id) as thisCount
from Table A, Table B
where Table A.id = TableB.id
Group by Table A.id

Can I do what I'm looking for??

Thanks
Keith

Hi,

I don't know if you can do this with one query but to get the remaining rows (where count is 0 in the other table) you can try the following query:

SELECT TableA.id
FROM TableA LEFT JOIN TableB
ON TableA.id = TableB.id
WHERE TableB.id is null

I figured it out. Helps to search the list... hehe

select a.id, Count(b.id)as CatCount
from images as a
Left join image_cat as b ON a.id=b.id

group by a.id

VERY FAST