库存存货对比

 select a.KCCKYE_CKBH,a.KCCKYE_WLBH,a.KCCKYE_PCH,a.KCCKYE_F1,a.KCCKYE_TSKC,a.KCCKYE_HWBH,a.KCCKYE_XGDX,a.KCCKYE_SLYE,b.KCWLYE_SLYE from (
 select * from KCCKYE WHERE KCCKYE_KJND    +KCCKYE_KJQJ='202502') a,(
 select * from KCWLYE WHERE KCWLYE_KJND    +KCWLYE_KJQJ='202502') b
 where a.KCCKYE_KJND=b.KCWLYE_KJND and a.KCCKYE_KJQJ=b.KCWLYE_KJQJ
 and a.KCCKYE_CKBH=b.KCWLYE_CKBH and a.KCCKYE_WLBH=b.KCWLYE_WLBH 
 and a.KCCKYE_PCH=b.KCWLYE_PCH and a.KCCKYE_F1=b.KCWLYE_F1 and a.KCCKYE_TSKC=b.KCWLYE_TSKC
 and a.KCCKYE_XGDX=b.KCWLYE_XGDX and a.KCCKYE_F2=b.KCWLYE_F2 and a.KCCKYE_F3=b.KCWLYE_F3
 and a.KCCKYE_HWBH=b.KCWLYE_HWBH
 and convert(int,a.KCCKYE_SLYE)<>convert(int,b.KCWLYE_SLYE ) 
 and KCCKYE_TSKC='Z' and KCCKYE_CKBH like '02%' AND KCCKYE_CKBH<>'02033'