From: | Anony Mous <a(dot)mous(at)shaw(dot)ca> |
---|---|
To: | 'elein' <elein(at)varlena(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Two joins on same foreign key |
Date: | 2004-01-31 19:18:40 |
Message-ID: | 005201c3e82f$08f5f6b0$7402a8c0@PETER |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I must say, I'm really appreciative with the responses from this list.
Thanks to all!
-----Original Message-----
From: elein [mailto:elein(at)varlena(dot)com]
Sent: January 31, 2004 12:10 PM
To: Anony Mous
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Two joins on same foreign key
PostgreSQL General Bits Issue #56 has an article on Join Basics
which also has an example of multiple table joins.
http://cookie.varlena.com/varlena/GeneralBits/56.php
--elein
elein(at)varlena(dot)com
On Fri, Jan 30, 2004 at 03:03:35PM -0700, Anony Mous wrote:
> Hi,
>
>
>
> I??m fairly new to this database, and have read much discussion on
> sub-queries. I??ve seen that they can be great for some queries, and
downright
> slow for others. I have a table with two foreign keys referencing another
> table, like:
>
>
>
> Table #1
>
> employee_id (pk)
>
> employee_name
>
>
>
> Table #2
>
> teamleader_employee_id
>
> backup_employee_id
>
>
>
> both fields in table 2 need to do a lookup in table 1 to get the name of
the
> actual employee. Do I need to use nested queries to accomplish this? Any
help
> is greatly appreciated!
>
>
>
> -AM
>
From | Date | Subject | |
---|---|---|---|
Next Message | Louis LeBlanc | 2004-01-31 19:41:15 | Re: Large object insert/update and oid use |
Previous Message | elein | 2004-01-31 19:09:37 | Re: Two joins on same foreign key |