select * from tabname A where A.id in (select id from tabname B where A.initial=B.initial …… <- 中国开发网

账号

登登录
先先随便看看

sea026 · 2007-09-17 16:24:02 · 阅读: 435

select * from tabname A where A.id in (select id from tabname B where A.initial=B.initial ……

select * from tabname A where A.id in (select id from tabname B where A.initial=B.initial order by id limit 5)

ERROR 1235: This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

相关信息: