Re: [SQL] Counting rows from two tables in one query

2004-04-10 Thread Bruno Wolff III
On Wed, Apr 07, 2004 at 10:06:20 +, Stefan Weiss <[EMAIL PROTECTED]> wrote: > Hi. > > What I am trying to get is a list that shows how many records from > 'sub_a' and 'sub_b' are referencing 'main': > > main_id | count_a | count_b > -+-+- > 1 | 2 | 1 >

Re: [SQL] Counting rows from two tables in one query

2004-04-09 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1

[SQL] Counting rows from two tables in one query

2004-04-09 Thread Stefan Weiss
Hi. I have a (simplified) table layout like this: +-+ +-+ | sub_a | +--+ | sub_b | +-+ | main | +-+ | id | +--+ | id | | main_id |