OraFAQ Forum: SQL & PL/SQL » 'Recursive' query?

Home » SQL & PL/SQL » SQL & PL/SQL » 'Recursive' query?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

'Recursive' query? [message #2340]

Mon, 08 July 2002 08:45

Mike Nibeck
Messages: 49
Registered: May 2002

Member

Not quite sure if 'recursive' is the right word or not, but here's what I have:

Customer Table
--------
Cust_ID (PK)
FName
LName
etc.
etc.

Marriage_Link table
-------------
Cust_ID (PK)
Marriage_Cust_ID

I need to query the Customer table based on a specified Cust_ID and the get FName, LName. I then need to link to the Marriage_Link table, get the Marriage_Cust_ID field, use that to re-query the Customer table to get the Fname, Lname of the spouse.

Ideas?

Thanks,

Mike

Report message to a moderator