= 0;
Jeez either I should be getting some coffee or some sleep
Peter Normann
-Original Message-
From: Jamie Tibbetts [mailto:[EMAIL PROTECTED]]
Sent: 18. juni 2002 22:21
To: Peter Normann; [EMAIL PROTECTED]
Subject: Re: Need help with a complex query
>>> Try - and I
>>> Try - and I mean *try* :-)
>>>
>>> SELECT Customers.* FROM Customers, Subscriptions
>>> LEFT JOIN Orders ON (Orders.customerid=Customer.CustomerID)
>>> LEFT JOIN Ordered_Items ON (Ordered_Items.orderid=Orders.id &&
>>> (Ordered_Items.productid = '23'))
>>> WHERE Customers.id=Subscriptions.cus
18
To: Peter Normann; [EMAIL PROTECTED]
Subject: Re: Need help with a complex query
> Try - and I mean *try* :-)
>
> SELECT Customers.* FROM Customers, Subscriptions
> LEFT JOIN Orders ON (Orders.customerid=Customer.CustomerID)
> LEFT JOIN Ordered_Items ON (Ordered_Ite
> Try - and I mean *try* :-)
>
> SELECT Customers.* FROM Customers, Subscriptions
> LEFT JOIN Orders ON (Orders.customerid=Customer.CustomerID)
> LEFT JOIN Ordered_Items ON (Ordered_Items.orderid=Orders.id &&
> (Ordered_Items.productid = '23'))
> WHERE Customers.id=Subscriptions.customerid
> AND
Try - and I mean *try* :-)
SELECT Customers.* FROM Customers, Subscriptions
LEFT JOIN Orders ON (Orders.customerid=Customer.CustomerID)
LEFT JOIN Ordered_Items ON (Ordered_Items.orderid=Orders.id &&
(Ordered_Items.productid = '23'))
WHERE Customers.id=Subscriptions.customerid
AND Subscriptions.li
