> >
> You need to get the conditions for the LEFT JOIN out of the WHERE clause:
>
> SELECT product_id, name, description, sales.sale_id
>   FROM products
>   LEFT JOIN sales ON
>     products.product_id = sales.product_id WHERE
>     sales.sale_id IS NULL AND
>     sales.customer_id = 10

>

I lied in my last email - this did do the trick!

I was not aware that you could stick multiple clauses for the "ON" section.
It all makes sense now!

Thanks again

Andy.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to