sql语句查询并统计 

select count(*) from (SELECT bg.GoodsID as gd1,bg.Minimum,bg.Maximum,ml.GoodsID as gd2 FROM Base_Goods bg right join Manage_Ledger ml on bg.GoodsID=ml.GoodsID
group by bg.GoodsID,bg.Minimum,bg.Maximum,ml.GoodsID having sum(ml.Number)>bg.Maximum
) as result
posted @ 2020-01-08 10:50  一只java小菜鸡  阅读(1412)  评论(0)  编辑  收藏  举报