如果仅满足where子句中的语句,我尝试从desiredValue
表中更新updatedTable
,否则不应该设置值。下面是正确的陈述吗?
update updatedTable si
set desiredValue = select desiredValue
from otherTable sl
where sl.att1 = si.att1 and sl.att2 = si.att2;
如果仅满足where子句中的语句,我尝试从desiredValue
表中更新updatedTable
,否则不应该设置值。下面是正确的陈述吗?
update updatedTable si
set desiredValue = select desiredValue
from otherTable sl
where sl.att1 = si.att1 and sl.att2 = si.att2;
尝试如下:
UPDATE updatedTable
set updatedTable.desiredValue = otherTable.desiredValue
FROM otherTable
WHERE updatedTable.att1 = otherTable.att1 and updatedTable.att2 = otherTable.att2