Explore BrainMass

Query Results - RIGHT Outer Join

Using the week 2 lecture database, if you wanted to see all the isbns from the books table and any matching isbns from the order_lines table, you'd want to do an outer join as such (because not every book stocked has been ordered):

SELECT books.isbn, order_lines.isbn
FROM books LEFT JOIN order_lines ON books.isbn = order_lines.isbn;

How would you get the same query results but writing the query as a RIGHT outer join?