解决方案: |
经询问客户,已经不需要这些存货记录了,所以删除这些不在存货档案中的记录 :
delete from UFDATA_005_2004..CurrentStock where cinvcode not in (select cinvcode from UFDATA_005_2004..inventory)
delete from UFDATA_005_2004..ia_subsidiary where cinvcode not in (select cinvcode from UFDATA_005_2004..inventory)
delete from UFDATA_005_2004..ia_summary where cinvcode not in (select cinvcode from UFDATA_005_2004..inventory)
delete from UFDATA_005_2004..st_totalaccount where cinvcode not in (select cinvcode from UFDATA_005_2004..inventory) |