暂时.sql

来自「手机进销存系统Delphi源码,管理手机的进货还有销售方面的功能」· SQL 代码 · 共 11 行

declare @tempid char(12)
set @tempid='SX2001010015
'
--未领未销未退
select count(*)from thrxx where thrxx.fid =@tempid and thrxx.fid not in (select fhrxx from tgtlh )and thrxx.fid not in(select fhrxx from tbs )
--已领未销，未退货
select count(*) from thrxx where thrxx.fid=@tempid and thrxx.fid  in(select fhrxx from tgtlh where tgtlh.fid not in(select fgl from tgtth)) 
--退库未回
select count(*) from thrxx where thrxx.fid=@tempid and thrxx.fid in(select fhrxx from tbs where tbs.fid not in(select fbs from tbsfh))
--已领已退
select count(*) from thrxx where thrxx.fid=@tempid and thrxx.fid in(select fhrxx from tgtlh where fid in(select fgl from tgtth))