--表a中字段值 pri_hwmc_mc1 不在表pri_hwmc中 pri_hwmc_mc1 的值
-- 根据一定条件 插数据
INSERT INTO pri_hwmc(pri_hwmc_mc1,pri_hwmc_mcsx1,pri_hwmc_mc8)
select pri_hwmc_mc1,pri_hwmc_mc1,pri_hwmc_mc8 from a where pri_hwmc_mc1
NOT in ( select pri_hwmc_mc1 from pri_hwmc)
--PEFECT
--step 2 两表间的字段更新
update b set b.cp_kcb_货物系编=pri_hwmc.pri_hwmc_xtbh
from b,pri_hwmc
where b.pri_hwmc_mc1 =pri_hwmc.pri_hwmc_mc1
--step 3
INSERT INTO cp_库存表(cp_kcb_数量,cp_kcb_备注,cp_kcb_货物系编,cp_kcb_加入原因,cp_kcb_仓库系编 )
select cp_kcb_期初数量,cp_kcb_备注,cp_kcb_货物系编,cp_kcb_加入原因,cp_kcb_仓库系编 from b
--找系统编号
--step 4
--更新进货日期,cp_kcb_date
评论