Mysql：1235 - This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'错误解决

select distinct b.sale_count
from product_sale b 
where b.pro_id 
in
(select a.pro_id from product a LIMIT 0,2);

错误描述[Err] 1235 - This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

只要在加一层就可以解决问题了

select distinct b.sale_count
from product_sale b 
where b.pro_id 
in
(select t.pro_id from (select a.pro_id from product a LIMIT 0,2) as t);

 

表结构如下: