Hello everybody.
I use mysql 4.0.24 as found in debian gnu/linux sarge.
$ mysql -u root
[...]
mysql> use mydb
[...]
Database changed
mysql> select * from SAMPLES S1 where exists (select * from SAMPLES S2 where
S1.ID = S2.ID);
ERROR 1064: 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 SAMPLES S2 where S1.ID = S2.ID)' at line
What's wrong with my query? Obviously the table SAMPLES and its column ID
exist.
TIA,
Lucio.
