How would you get the same query results but writing the


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

Solution Preview :

Prepared by a verified Expert
Database Management System: How would you get the same query results but writing the
Reference No:- TGS01259161

Now Priced at $20 (50% Discount)

Recommended (99%)

Rated (4.3/5)