How to retrieve this data as a single row with three new columns
Posted by: V Ra
Date: September 04, 2012 05:54PM

I have the following tables:

user {user_id, name}
family {child_id, mother_id, father_id, address, household_income}

I want to select a row in family given child_id, mother_id and father_id and have it return all the columns in family along with the 3 new columns for the names of the users associated with child_id, mother_id and father_id

family {child_id, mother_id, father_id, address, household_income, child_name, mother_name, father_name}

Is this possible?

Thanks



Edited 1 time(s). Last edit at 09/04/2012 07:13PM by V Ra.

Options: ReplyQuote


Subject
Written By
Posted
How to retrieve this data as a single row with three new columns
September 04, 2012 05:54PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.