selecting foreign key into a column
Hello,
Can someone teach me, how to SELECT a foreign key into a column.
For example, I have this table :
USER_TABLE
userID
name
password
BOOK_TABLE (many book to one user)
bookID
userID
bookName
and the thing that I want to select per record is, userID and list of bookID as a column (seperated by ',' delimiter).
Subject
Views
Written By
Posted
selecting foreign key into a column
3559
May 04, 2013 08:13PM
1833
May 04, 2013 09:37PM
3985
May 22, 2013 12:06AM
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.