更新Access的语法 [英] Update syntax for Access
本文介绍了更新Access的语法的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我需要根据与另一个表的匹配来更新一个字段(当前为空).这应该很简单,但是我的语法是错误的.
I need to update a field (which is currently empty) based on a match with another table. This should be simple, but my syntax is wrong.
在SQLServer 2005中,语法为
In SQLServer 2005, the syntax would be
UPDATE Facilities-NOID
SET Facilities-NOID.ID = Facilities-ID.ID
FROM Facilities-NOID, Facilities-ID
WHERE [Facilities-ID].[Structure ID] = [Facilities-NOID].[Structure ID];
访问不喜欢那条FROM行,但是如果我忽略它,它需要每个ID.这应该很简单,但是我没有在MS帮助中看到Update语法.
Access doesn't like that FROM line, but if I leave it out, it wants each ID. This should be simple, but I'm not seeing it in the MS help on the Update syntax.
推荐答案
我认为这是您想要的:
UPDATE Facilities-NOID
INNER JOIN Facilities-ID ON Facilities-NOID.[Structure ID]
= Facilities-ID.[Structure ID]
SET Facilities-NOID.ID= Facilities-ID.ID
您正在根据设施ID中出现的结构ID匹配来更新设施NOID.
You are updating Facilities-NOID based on a match on Structure ID occurring in Facilities-ID.
这篇关于更新Access的语法的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文