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);
表结构如下:
