two foreign keys

From: Brian <Brrrian(at)Excite(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: two foreign keys
Date: 2002-02-16 21:18:45
Message-ID: 5.1.0.14.2.20020216131821.00adc9a0@mail.attbi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I have a table that has two foreign keys to the same table.

- operator_id_start
- operator_id_stop

Both point to the operator table.

When displaying the row from the table how do I join so that I can have both Operator table details available?

-----

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Patrick Hatcher 2002-02-16 21:58:33 Re: Updated to 7.2 now can't createlang..
Previous Message PG Explorer 2002-02-16 20:39:00 Re: Updated to 7.2 now can't createlang..