有批次和无批次数据异常比对 

select b.material_number,b.material_name,a.count,b.count_nobatch 

from (

select w.material_number, sum(w.count) as count 

from t_warehouse_material w 

where w.warehouse_number='cd_10001' 

group by w.material_number

) a

full join 

(

select n.material_number,n.material_name, n.stock_count as count_nobatch 

from t_warehouse_material_nobatch n 

where n.warehouse_number='cd_10001'

) b

on a.material_number = b.material_number

   where a.count!=b.count_nobatch

order by b.material_number asc

原文链接：https://blog.csdn.net/xuanjiewu/article/details/78815736

本站声明:网站内容来源于网络,如有侵权,请联系我们,我们将及时处理。