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