Posted by Jens on 09/13/05 18:23

Select parent_name, SubQuery.Sum_of_children from parent
INNER JOIN
(
Select parent_row_id,COUNT(*) from children group by
parent_row_id
) SubQuery
ON SubQuery.parent_row_id = parent.row_id

HTH, Jens Suessmeyer.

• Next in forum: Re: How to count
• Prev in forum: How to count
• Thread view: Re: How to count

[Reply to this message]