Re: Multiple left joins and counts

[Does it matter]

I was forgetting :

when I was having a LEFT JOIN onto only one table, it seemed to produce the proper result :

SELECT t1.* , COUNT(t2.id)
FROM table1 AS t1
LEFT JOIN
table2 AS t2
ON t1.id_t1 = t2.id_t1
GROUP BY id_t1