mysql gurus

[seby]

for the life of me i cannot figure this out, i need to select all on one table, and count an "id" on two other tables, using two left joins...

can anyone show me an example how to do this? i know how to use basic left joins, but cant figure out how to count the number of ID's via left join.

[MungoBBQ]

Tables are a, b and c

SELECT a.*, count(b.id), count(c.id) FROM a LEFT JOIN b ON b.id = a.id LEFT JOIN c ON c.id = a.id

Should work with the proper GROUP BY clauses. Just try it out.