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?
Attachment:- WEEK2_ACCESS2000.zip