Hi,

My server version : 4.0.18-max-nt My OS : Windows XP

This is what I get when I do status command on mysql prompt.

mysql> status;

-------------- mysql Ver 12.22 Distrib 4.0.18, for Win95/Win98 (i32)

Connection id: 3 Current database: perlclass Current user: root@localhost SSL: Not in use Server version: 4.0.18-max-nt Protocol version: 10 Connection: localhost via TCP/IP Client characterset: latin1 Server characterset: latin1 TCP port: 3306 Uptime: 8 min 49 sec

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); 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