Access 表相关

//多表更新

update Package2,MeasItemsPresetSys set Package2.DefaultFormulaID = MeasItemsPresetSys.DefaultFormulaID where Package2.ID = MeasItemsPresetSys.MeasItemID; 

原文地址:https://www.cnblogs.com/waterair/p/7039561.html