Re: Two joins on same foreign key - Mailing list pgsql-general

From Michael Glaesemann
Subject Re: Two joins on same foreign key
Date
Msg-id 1CBA249C-53DB-11D8-AB38-000A95C88220@myrealbox.com
Whole thread Raw
In response to Re: Two joins on same foreign key  (Anony Mous <a.mous@shaw.ca>)
List pgsql-general
On Jan 31, 2004, at 3:35 PM, Anony Mous wrote:

> Actually, given that there may not always be a backup_employee field
> (can be
> null) I think I'm forced to use an outer join to return all team leader
> records regardless if a matching backup_employee record exists.

yup. Actually, I hadn't seen the other responses when I first posted.
You've got some options, it looks like. :)
Michael Glaesemann
grzm myrealbox com


pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Creating 'global' functions.
Next
From: "John Sidney-Woollett"
Date:
Subject: Unicode vs SQL_ASCII DBs