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]
