lmis庫存預占修改

在lmis.jc_spzl裡查找spid

修改

select * from lmis.jc_spzl  t where t.shangp_no in('B201363','A103211')

select t.rowid,t.* from kc_spphhw t   WHERE shangp_id in ('SPH00061803','SPH00063737')

select t.rowid,t.* from kc_spkbkc t   WHERE shangp_id in ('SPH00061803','SPH00063737')

select t.rowid,t.* from kc_spzkc t   WHERE shangp_id in ('SPH00061803','SPH00063737')

中rukyz_num的數量換到num中即可

本文轉自 qvodnet 51CTO部落格，原文連結:http://blog.51cto.com/bks2015/1699582