Try something like this:
SELECT ID,NAME,COUNT(*) FROM tableA LEFT JOIN tableB ON tableA.ID = tableB.ID GROUP BY ID,NAME
Nope, sorry, that won't work, ID exists in both tables thus it must be prefixed with table name or alias: SELECT tableA.ID,... GROUP BY tableA.ID,...
But Shawn Green allready gave you the answer, so I suppose you are in control of things. :)
-- Roger
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
