Version 4.0 doesn't support subqueries. In any event, your query would return all rows from channels as long as there are any rows in users, which I doubt is what you intended.
--- nambi c <[EMAIL PROTECTED]> wrote: > 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]