34,588
社区成员
发帖
与我相关
我的任务
分享
--修改
select
*
from
货位表
where
checksum(wh,style)
not in
(select checksun(wh,style) from 库存表)
select
*
from
货位表
where
checksum(*)
not in
(select checksun(*) from 库存表)
select m.* from 货位表 m where not exists(select 1 from 库存表 n where n.wh = m.wh and n.style = m.style)
select * from 货位表 a
where not exists (
select 1 from 库存表
where wh=a.wh and style=a.style
and Qty > 0
)
select 仓库,货号 from 库位表
except
select 仓库,货号 from 库存表