access 数据更新语句

UPDATE YS_POINT AS a, YS_LINE AS b SET a.管线高程 = b.SELEV1
WHERE (((a.物探点号)=[b].[起点号]));

原文地址:https://www.cnblogs.com/zmbhfly/p/8032605.html