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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
