门店盘点检查商品货位

wbv123

select a.wareid
from u_ware_q a(nolock), u_store_i b(nolock), u_store_c c(nolock), c_stall d(nolock), c_org_busi e(nolock)
where a.wareid = b.wareid
and b.wareid = c.wareid and b.batchno = c.batchno and b.idno = c.idno
and c.stallno = d.stallno
and e.busno = c.busno
and ( e.orgtype <> ’10’ and d.stalltype like ‘2%’)
and c.wareqty – c.awaitqty <> 0
and exists (select 1 from u_check_reg, c_org_busi where checkno = ‘2102220000002’ and u_check_reg.busno = c_org_busi.busno and c_org_busi.busno = c.busno )