Hi, I'm trying to figure out how to apply these from the manual, but to
no avail. Is it possible that my version (4.0.18) does not implement
these?
I have two tables: products and products_by_product_area. Both have a
field "product". I try
SELECT product from products WHERE NOT EXISTS (SELECT
]
Sent: Friday, June 18, 2004 2:38 PM
To: Anton Ivanov
Cc: [EMAIL PROTECTED]
Subject: Re: EXISTS/NOT EXISTS
Subqeries require mysql 4.1.
The manual offers some suggestions on rewriting subqueries as JOINs
<http://dev.mysql.com/doc/mysql/en/Rewriting_subqueries.html>.
In your case, yo