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: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
	I am trying to join 3 tables
with this query
	select,, sum(b.qty), sum(c.qty)
	from a, b, c
	where and and

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

Jeff Meeks


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-2017 The PostgreSQL Global Development Group