From: Haywood J'Bleauxmie <hj@fc3.outerscape.net>
To: pgsql-sql@postgresql.org
Subject: left join syntax
Date: Tue, 08 May 2001 02:36:14 -0500
Message-ID: <fc.009863ef00002846009863ef00002846.284b@fc3.outerscape.net> (raw)
I have a database that tracks work orders. Each order tracks two entries
from the employees table; the employee ID of the person assigned to the
work order and the ID of the person who completed the order. Each work
order may have one, both, or neither field filled in. As such, I need to
left join the employee table to the work order table, but I cannot figure
out the syntax for the double-join. As independent selects, I can do the
join:
SELECT o.ordr_id, a.last_name
FROM ordr o left join employee a on o.assigned_id = a.emp_id;
SELECT o.ordr_id, c.last_name
FROM ordr o left join employee c on o.completion_id = c.emp_id;
But I would like to have the whole thing in a single SELECT. Can you help
me out?
------------------------------------------------
Haywood J'listzen
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: hj@fc3.outerscape.net
Subject: Re: left join syntax
In-Reply-To: <fc.009863ef00002846009863ef00002846.284b@fc3.outerscape.net>
References: <fc.009863ef00002846009863ef00002846.284b@fc3.outerscape.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox