门店不能盘点检查

wbv123

select c.*
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 = ‘2108160000001’ and u_check_reg.busno = c_org_busi.busno and c_org_busi.busno = c.busno )

查待检货位或者不合格货位 语句

‘2108160000001’ 这个是盘点登记单号