Hi Dvoracek,
I think you forgot to put firstly "GROUP BY one.id"
so your select statement must be as :
SELECT one.descr, COUNT(two.id) xxx
FROM one LEFT JOIN two USING(id)
GROUP BY one.id, two.id
ORDER BY one.id;
Regards,
Tolga GOZE
Oksijen Teknoloji
www
Hi Dvoracek,
I think you forgot to put firstly "GROUP BY one.id"
so your select statement must be as :
SELECT one.descr, COUNT(two.id) xxx
FROM one LEFT JOIN two USING(id)
GROUP BY one.id, two.id
ORDER BY one.id;
Regards,
Tolga GOZE
Oksijen Teknoloji
www