Get information from multiple tables in one single query
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?
Subject
Written By
Posted
Get information from multiple tables in one single query
October 28, 2011 05:00AM
November 01, 2011 03:45PM
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.