Selecting number of "many" in 1-to-many

From: <jrcairns_at_hotmail.com>
Date: Wed, 06 May 1998 10:15:44 -0600
Message-ID: <6ipur1$22p$1@nnrp1.dejanews.com>

I'm trying to figure out how to select the number of children each parent has.

For example, say Table1 (Parent) has a 1-to-many relationship with Table2 (Children); that is, Table1 can have many Table2 records.

For each record in Table1, I want to know the number of times it appears in Table2 as a Parent, i.e. For each Parent (in Table1), how many Children (records in Table2) does it have?

Thanks,

jody

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed May 06 1998 - 11:15:44 CDT