Skip site navigation (1) Skip section navigation (2)

Joining more than 2 tables

From: Jeff Meeks <jmeekssr(at)net-serv(dot)com>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Joining more than 2 tables
Date: 2001-04-29 00:42:17
Message-ID: 3AEB6369.DA565D27@net-serv.com (view raw or flat)
Thread:
Lists: pgsql-general
Hi,
	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

Thanks 
Jeff Meeks
jmeekssr(at)net-serv(dot)com

Responses

pgsql-general by date

Next:From: Justin CliftDate: 2001-04-29 05:02:08
Subject: Re: Re: On the _need_ to vacuum...
Previous:From: Eric G. MillerDate: 2001-04-28 21:05:19
Subject: Re: function with multi-values

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group