|
Posted by Bandul on 04/25/06 23:21
Thanks strawberry
"strawberry" <zac.carey@gmail.com> wrote in message
news:1145980780.415994.238000@y43g2000cwc.googlegroups.com...
> 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]
|