Re: Count the children

On Tue, Aug 18, 2009 at 10:34 AM, Michael Rowan <mike(dot)rowan(at)internode(dot)on(dot)net
> wrote:

> 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;

Or am I missing something a subtlety?

Sean