|
Posted by Janwillem Borleffs on 11/11/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
Navigation:
[Reply to this message]
|