|
|
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
Navigation:
[Reply to this message]
|