[dbs] SQL Fehler ?

[Sven Eicher]

Hallo

> SELECT DISTINCT * FROM products
> WHERE EXISTS ( SELECT * FROM soldproducts , products WHERE
> soldproducts.customerID=1 AND products.productID =soldproducts.productID
> )

http://dev.mysql.com/doc/mysql/de/ANSI_diff_Sub-selects.html

User Comments

The EXISTS clause in a subquery isn't supported below version 4.1 !!! (Alas, 
the manual shipped with version 4.0.15 says that a subquery can be used with 
EXISTS)


-- 
Koala