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