select * from a where uin in (select uin from b where date = '2010-08-18'); select * from a
select uin from b where date = '2010-08-18'都有结果
提示:
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 uin from b where date = '2010-08-18')'
这个不是sql的标准语法么,网上搜了下也是这样写啊
select uin from b where date = '2010-08-18'都有结果
提示:
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 uin from b where date = '2010-08-18')'
这个不是sql的标准语法么,网上搜了下也是这样写啊
不知道是否支持子查询哦 但是in不是标准sql么
升级吧
操了,狗日的mysql,