SM55116调整存货

select id, qmsl,qmje,pjdj from sm_ch_chcl7_tb where ckid=27 
and to_char(nfyf,'yyyymm')='202507' and qmsl<>0 and qmje=0 
and  wlid in (select id from sm_zdb_xtwl_tb wl where wl.xtwllbid
in (select id from sm_zdb_xtwllb_tb t where t.superior_id in (366)) )

update sm_ch_chcl7_tb t set t.pjdj=16.02,qmje=16.02  where id=7910155;
commit;