Access 不支持 Update 的 From 子句!Update Data Set Lon=lon + (select ELon from DiffData Where Data.GTime=DiffData.GTime) -(select Lon from DiffData Where Data.GTime=DiffData.GTime) Where GTime in (select GTime from DiffData)
UPDATE Data INNER JOIN DiffData ON TData.GTime=DiffData.GTime SET Data.Lon = Data.Lon+DiffData.ELon-DiffData.Lon
在access 里已经帮你解决了,自己去看看
再简化: Update Data Set Lon=lon + (select ELon - Lon from DiffData Where Data.GTime=DiffData.GTime) Where GTime in (select GTime from DiffData)
Set Lon=lon + (select ELon from DiffData Where Data.GTime=DiffData.GTime)
-(select Lon from DiffData Where Data.GTime=DiffData.GTime)
Where GTime in (select GTime from DiffData)
INNER JOIN DiffData ON TData.GTime=DiffData.GTime
SET Data.Lon = Data.Lon+DiffData.ELon-DiffData.Lon
Update Data
Set Lon=lon + (select ELon - Lon from DiffData Where Data.GTime=DiffData.GTime)
Where GTime in (select GTime from DiffData)