I need what sounds like a very simple query - but I'm darned if I can figure it out.
I have two tables, parent and child related by child.parent_id = parent.id The query should return, for each parent row, parent.name and number of child rows
Hi, Michael.
select parent.name,count(*) from parent join child on child.parent_id=parent.id;