[dbs] SQL Fehler ?

[News]

Hallo,

ich benutze folgenden Befehl:

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


Daraufhin erhalte ich folgenden Fehler. Was mache ich falsch ?

You have an error in your SQL syntax. Check the manual that corresponds
to your MySQL server version for the right syntax to use near 'EXISTS (
SELECT * FROM soldproducts , product