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