phpbar.de logo

Mailinglisten-Archive

[dbs] SQL Fehler ?

[dbs] SQL Fehler ?

Sven Eicher phpbar at koalashome.de
Sam Jul 17 15:29:09 CEST 2004


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

php::bar PHP Wiki   -   Listenarchive