//多表更新
update Package2,MeasItemsPresetSys set Package2.DefaultFormulaID = MeasItemsPresetSys.DefaultFormulaID where Package2.ID = MeasItemsPresetSys.MeasItemID;
Access 表相关
原文:http://www.cnblogs.com/waterair/p/7039561.html