Andy Jefferson <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm using MySQL 4.0.15 and have been trying to use EXISTS/NOT EXISTS ...
> with no success - getting "You have an error in your SQL syntax".
>
> I've got 2 tables A and B and am trying something like this
>
> SELECT THIS.A_ID FROM A THIS
> WHE
> Does EXISTS exist in 4.0.15 ? or is it introduced in 4.1.*. If it does
> exist, what is incorrect in the syntax above ? (it matches the MySQL
manual
> example from what I can see).
Subqueries (http://dev.mysql.com/doc/mysql/en/Subqueries.html) were only
introduced in version 4.1, so I don't thin
Hi,
I'm using MySQL 4.0.15 and have been trying to use EXISTS/NOT EXISTS ...
with no success - getting "You have an error in your SQL syntax".
I've got 2 tables A and B and am trying something like this
SELECT THIS.A_ID FROM A THIS
WHERE NOT EXISTS
(SELECT THIS_ITEMS.B_ID FROM B THIS_ITEMS WHE
