Subqueries aren't implemented in 4.0 - only 4.1 and upwards support subqueries.
Cheers Andrew. ----- Original Message ----- From: "nambi c" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, July 22, 2004 10:31 PM Subject: subquery problem. > Hi, > > My server version : 4.0.18-max-nt > > I have created 2 tables 'channels' and 'users' in my > database. I can query these tables individually. I am > trying to execute a query with 'exists' clause. > > mysql> select * from channels where exists (select * > from users); > > This give the following error. > > ERROR 1064: You have an error in your SQL syntax. > Check the manual that corresp > onds to your MySQL server version for the right syntax > to use near 'exists (sele > ct * from users)' at line 1 > > > I am getting this syntax error message. The query > seems perfect to me. Any clue what is happening? Help! > > -Nambi > > > > > __________________________________ > Do you Yahoo!? > Yahoo! Mail is new and improved - Check it out! > http://promotions.yahoo.com/new_mail > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]