Query Help
Posted: Sun Oct 03, 2004 7:32 pm
Is it possible to use COUNT(*) when using an OUTER JOIN. My query looks like:
I wish for the members ID to be shown but at the same time I wish to count the number of rows which hold the same ID as members.
Code: Select all
SELECT members.ID, comments.comment FROM members, comments
WHERE members.ID = comments.ID;