RT,MYSQL现在版本子查询中不支持limit,也就是 select * from xx1 where id in (select id from xx2 limit 100)会提示语法错误。但是如果写成select * from xx1 where id in (select tmp.id from (select id from xx2 limit 100) as tmp) 就没问题。想讨论下,这个问题的来由是什么呢?
调试欢乐多
(select id from xx2 limit 100) b
on a.id=b.id