试试
select a.*,count(b.pid) as numbers from 产品 a left join 订单 b on a.id=b.pid group by b.pid order by numbers
但是这样的表设计不太合理.
mysql排序的问题点击打字试试selecta.*,count(b.pid)as
试试
select a.*,count(b.pid) as numbers from 产品 a left join 订单 b on a.id=b.pid group by b.pid order by numbers
但是这样的表设计不太合理.