MySQL Forums
Forum List  »  MySQL Query Browser

Get information from multiple tables in one single query
Posted by: Even Augdal
Date: October 28, 2011 05:00AM

Lets say I got these 3 tables:

1. Users
user_id, user_firstname, user_lastname

2. Books
book_id, book_title, book_author

3. UserBooks
userBook_id, userBook_userId, userBook_bookId

I want to list 5 users and all their books like:

Adam: Harry Potter
The Lord of the Rings
Random Cookbook.

Martin: Book of Love
How to surprise a woman.


Is that possible with one single query?

Options: ReplyQuote


Subject
Written By
Posted
Get information from multiple tables in one single query
October 28, 2011 05:00AM


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.