Posted by strawberry on 04/25/06 18:59

SELECT title
FROM orders, customers, order_items
LEFT JOIN books ON books.isbn = order_items.isbn
WHERE orders.customerid = customers.customerid
AND order_items.orderid = orders.orderid
AND customers.name = 'John'
LIMIT 0 , 30

[Back to original message]