SQL 多库存查询

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

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