MySQL Forums
Forum List  »  Quality Assurance

selecting foreign key into a column
Posted by: ahmad rahimie
Date: May 04, 2013 08:13PM

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).

Options: ReplyQuote


Subject
Views
Written By
Posted
selecting foreign key into a column
3651
May 04, 2013 08:13PM


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.