Hi John, John Sidney-Woollett schreef: > Useful to add a title to your messages before you post... It escaped before finishing..... > How about: > > select parentid, count(*) as number_of_children > from childtable > group by parentid > order by parentid; It works but can you tell me why this works? Is the count(*) over the "group by parentid"?
Groeten, Joost Kraaijeveld Askesis B.V. Molukkenstraat 14 6524NB Nijmegen tel: 024-3888063 / 06-51855277 fax: 024-3608416 e-mail: [EMAIL PROTECTED] web: www.askesis.nl ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
