Is it This Join Condition Do-Able?

From: "Lane Van Ingen" <lvaningen(at)esncc(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Is it This Join Condition Do-Able?
Date: 2005-08-17 16:54:50
Message-ID: EKEMKEFLOMKDDLIALABIAEHJCBAA.lvaningen@esncc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Given three tables: a, b, c ; each consist of a 'keyfld' and a field called
'foo':
tbl a tbl b tbl c
--------- --------- ---------
a.keyfld b.keyfld c.keyfld
a.foo1 b.foo2 c.foo3

I want to always return all of tbl a; and I want to return b.foo2 and c.foo3
if
they can be joined to based on keyfld.a; I know that it will involve a LEFT
OUTER
JOIN on table a, but have not seen any examples of joins like this on 3 or
more
tables.

select a.keyfld, a.foo1, b.foo2, c.foo3
from a, b, c
where a.keyfld = <some value>
and a.keyfld = b.keyfld
and a.keyfld = c.keyfld;

Results could look like this:
a.keyfld a.foo1 b.foo2 c.foo3
xxxx xxxx xxxx (null)
xxxx xxxx (null) xxxx
xxxx xxxx (null) (null)
xxxx xxxx xxxx xxxx

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Dmitri Bichko 2005-08-17 17:25:53 Re: Is it This Join Condition Do-Able?
Previous Message Frank Bax 2005-08-17 16:46:01 Re: [despammed] converting varchar to integer