At 5:08 pm -0800 22/2/06, Scott Haneda wrote:
>I think we are close, thanks
>ERROR 1120: Cross dependency found in OUTER JOIN. Examine your ON
>conditions
> > SELECT p.id, p.prod_name, sum(oi.quantity) as qty
>> FROM Products p
>> LEFT JOIN orders as o
>> ON (p.id = oi.product_id)
Maybe this is where your problem is - you're joining to orders but referencing
order_items in your join condition. Shurely shome mishtake?*
> > AND o.created BETWEEN "2005-01-01 00:00:00" AND "2006-02-22
> > 23:59:59"
>> AND o.status not IN ('cancelled', 'pending', 'ghost')
>> LEFT JOIN order_items as oi
>> ON (o.id = oi.order_id)
>> GROUP BY p.id
> > ORDER by qty ASC
* ask a Brit, or consult
http://en.wikipedia.org/wiki/Private_Eye#Examples_of_humour
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
