Posted by Janwillem Borleffs on 11/04/45 11:17

pauld wrote:
> I want all those names where the custID doesnt appear in vists
>
> select name FROM demographic WHERE NOT EXISTS (SELECT custID FROM
> visits WHERE demographic.custID=visits.custID);
>
> is a syntax error

Which version of MySQL are you using? This syntax is supported by MySQL
version 4.1 and up.


JW

[Back to original message]