Dear my friends...
I don#t understand why subquery on my MySQL 4.0.18-Mas
does not valid.
Here what I have done.
"
[EMAIL PROTECTED]:~> mysql -h 192.168.23.1 -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or
\g.
Your MySQL connection id is 354744 to server version:
4.0.18-Max
Type 'help;' or '\h' for help. Type '\c' to clear the
buffer.
mysql> use bernstein;
Reading table information for completion of table and
column names
You can turn off this feature to get a quicker startup
with -A
Database changed
mysql> select * from salesreport where custid in
(select custid from appointment where done='N');
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 'select
custid from appointment where done='N')' at line 1
mysql>
Please tell me....
Thank you very much in advance.
__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
