select * from intd as a left join (select *,sum(xm3) sumxm3,sum(xm3 * xm4) from xiaohao where xm2 like '2018-09%') as b on a.id = b.xm1 ORDER BY b.sumxm3 desc
mysql联表查询并排序实例
最新推荐文章于 2024-04-02 16:46:28 发布
select * from intd as a left join (select *,sum(xm3) sumxm3,sum(xm3 * xm4) from xiaohao where xm2 like '2018-09%') as b on a.id = b.xm1 ORDER BY b.sumxm3 desc