Hi all,
Is it possible to count and display the number of children of a parent in a generic query?
parent table: id
child table: id, parent_id
Example output of the query:
parentid number_of_children
parent1 2
parent2 6
parent3 0
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J.Kraaijeveld@Askesis.nl
web: www.askesis.nl