Re: Count the children

On Tue, Aug 18, 2009 at 10:50 AM, Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> wrote:

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

I missed a "group by parent.name" above.

>
> Sean
>
>
>