How to: SQL Query with multiple FK relations to single table

From: Carl <carl.stottlemyer_at_lmco.com>
Date: 25 Sep 2002 06:44:22 -0700
Message-ID: <bc814416.0209250544.5ffe57d3_at_posting.google.com>

The following example seems like it should be simple but it is stumping me. How would you construct a SQL query that prints out the name (referenced in the People table) of the father and son identified in the fathers table.

Table Fathers

fatherNo (references People.pplNo)
sonNo (references People.pplNo)

Thanks,
Carl Received on Wed Sep 25 2002 - 15:44:22 CEST

This message: [ Message body ]
Next message: Berend: "Calling PL/SQL package (that returns a table) from a package"
Previous message: Robert: "Trouble with Trigger raising "no data found""
Next in thread: Carl: "Re: How to: SQL Query with multiple FK relations to single table"
Reply: Sybrand Bakker: "Re: How to: SQL Query with multiple FK relations to single table"
Reply: Carl: "Re: How to: SQL Query with multiple FK relations to single table"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message