我有两个表fullInfo
和fundInfo
。fullInfo
是一个完整的数据集捐赠给非营利组织。fundInfo
是具有相应id号的唯一基金子组列表。我正试图将基金id号从fundInfo
插入fullInfo
的列fundId中,该列存在但目前具有NULL值。
fullInfo
:
id funddesc amount fundId
002 GENERAL 25.00 NULL
044 MAINT 50.00 NULL
122 TRAVEL 75.00 NULL
... ... ... ...
fundInfo
:
id funddesc
01 MAINT
02 TRAVEL
03 GENERAL
... ...
update fullInfo
set fullInfo.fundId = fundInfo.id
where fullInfo.funddesc = fundInfo.funddesc;
这个代码不能工作。有什么建议吗?
update fullInfo
set fullInfo.fundId = fundInfo.id
from
fundInfo
where fullInfo.funddesc = fundInfo.funddesc;
UPDATE fullInfo
INNER JOIN fundInfo
ON fullInfo.funddesc = fundInfo.funddesc
SET fullInfo.fundId = fundInfo.id;