我所使用的mysql version 是 4.0.10 gamma 當我使用如下語法時產生錯誤訊息 語法: select bb from aa where bb in (select bb from cc) ; 錯誤訊息 : 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 bb from cc)' at line 1 請問應如何解決 ???

MySQL 不知道出到第幾版了？ 4.0 版之前是不支援 Sub Select 的 參看: http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html 裏面說, 可以改用 IN 的語法。 發表人 - hagar 於 2003/02/19 08:44:20

引言: 我所使用的mysql version 是 4.0.10 gamma 當我使用如下語法時產生錯誤訊息 語法: select bb from aa where bb in (select bb from cc) ; 錯誤訊息 : 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 bb from cc)' at line 1 請問應如何解決 ???

MySQL Server currently only supports nested queries of the form INSERT ... SELECT ... and REPLACE ... SELECT .... 文件說 MySQL 預計 4.1 版以後才支援 SubSelect. SQL 須改寫 join / left join : select aa.bb from aa,cc where a.bb=cc.bb; /* Free 和 Create 一樣重要 */ 發表人 - Mickey 於 2003/02/19 09:00:22