I am trying to join 3 tables
with this query
select a.id, a.name, sum(b.qty), sum(c.qty)
from a, b, c
where a.id=xxx and b.id=a.id and c.id=a.id
what the sums that get returned look as if they are a cross products of
the b and c tables.
What is the correct way to join these tables?
Pointers to docs is welcome
pgsql-general by date
|Next:||From: Justin Clift||Date: 2001-04-29 05:02:08|
|Subject: Re: Re: On the _need_ to vacuum...|
|Previous:||From: Eric G. Miller||Date: 2001-04-28 21:05:19|
|Subject: Re: function with multi-values|