[求助]感觉我的MySQL不支持嵌套查询
请大侠高手帮忙找问题,解决啊!!!select * from data where classid not in (select classid from data where weekday = 3 and daytime=1);
此语句我断开试过,两分句都没问题,可用not IN 或 in连起来,就报错:
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 classid from data where weekday = 3 and daytime = 1 ) L
我的版本MySQL 4.0.26-nt
[此贴子已经被作者于2006-9-7 10:13:36编辑过]