Select count(tablechild.someid) as itemcount, tableparent.description ; from tableparent ; left outer join tablechild ; on tablechild.someid = tableparent.someid ; group by tableparent.someid,tableparent.description>In a one to many relationship between a parent and child table, what is the lightest way to count() the child table and return the parent description in one SQL statement?
>Select count(tablechild.someid) as itemcount, tableparent.description ; > from tablechild ; > left outer join tableparent ; > on tablechild.SomeID=tableparent.SomeID ; > group by tablechild.someid,tableparent.description >>