Re: SubQueries and IN

[Andy Hall]

> >
> 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.