update大侠帮忙，简单更新update

[tylike]

update (SELECT dbo.HY_YHXX.ID, dbo.HY_YHXX.N_FPFDE, tx.jse, t1.jr,
dbo.HY_YHXX.D_FPND
FROM dbo.HY_YHXX LEFT OUTER JOIN
OPENROWSET('SQLOLEDB', 'ch\yzg'; 'sa'; '123456',
'select hy_old.dbo.money_in.group_no,max(hy_old.dbo.money_in.jfrq) as jr from hy_old.dbo.money_in group by hy_old.dbo.money_in.group_no')
t1 ON
dbo.HY_YHXX.C_XKZH = t1.group_no COLLATE Chinese_PRC_CI_AS LEFT OUTER JOIN
OPENROWSET('SQLOLEDB', 'ch\yzg'; 'sa'; '123456',
'select hy_old.dbo.motorcade.xkzh,hy_old.dbo.motorcade.jse from hy_old.dbo.motorcade')
tx ON dbo.HY_YHXX.C_XKZH = tx.xkzh COLLATE Chinese_PRC_CI_AS) as xx
set xx.n_fpfde=xx.jse,d_fpdn=jr
无法执行，怎么写
其实就是找到一个结果集，将查的结果，更新到有主键的库

[zlp321002]

set 的左边的字段不能用别名代替!

[tylike]

解决了，用FROM

[Andy__Huang]

update tb set col1=..... from ....

所有的關聯要寫在 from 的后面