mysql in和limit不能同时使用

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

我的mysql是这样的：

select * from User where UID in(select HelpUID from SplitActivity where UserJoinActivityID =(select ID from UserJoinActivity where RandNumber='xotgf' limit 1) limit 6);

后来发现解决办法是先做一张临时表

改成这样

select * from User where UID in(select HelpUID from(select HelpUID from SplitActivity where UserJoinActivityID =(select ID from UserJoinActivity where RandNumber='xotgf' limit 1) limit 6) a);

问题解决