Need help with Access SQL
Posted by:
Jer F
Date: November 24, 2009 03:27PM
Alright, I've been working on some problems for my college course and I can't seem to figure out why I'm returning so many results. The question asks:
For each order that includes the books with the ISBNs 014025448X or 0670894370, list the order id, order date, client email address, first name, last name, ISBN, title, sale price, and quantity of each book included in the order. Put the list in order of order date, then title.
Here is what I came up with for this.
SELECT [order.id], [order_date], client.email, client.fname, client.lname, isbn, title, sale_price, quantity
FROM client, [order], book, lineitem
WHERE isbn="014025448X" OR isbn= "0670894370"
ORDER BY [order_date], title;