I have a query that starts with the line:
SELECT books.isbn, order_lines.isbn
...why would I want to see isbns from two different tables? What sort of query would warrant that - an inner join or an outer join?
Assume the table "books" contains books that the company stocks. Assume the table order_lines only contains books that have actually been ordered.