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);

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);