7,714
社区成员
发帖
与我相关
我的任务
分享
SELECT CODE, NAME, GPJC, GPZWJC
FROM TOTAL INNER JOIN GPK ON TOTAL.CODE=GPK.GPJC;
update 查询1 set name=gpzwjc
update [total] inner join gpk on [total].code=[gpk].gpjc
set [total].[name]=[gpk].[gpzwjc]
update [total] set [name]=dlookup("gpzwjc","gpk","gpjc='" & [code] & "'")