更新字段出错

[wuzhibumian]

update employee set employee.educationid=k.educationid
from (select employeeid ,educationid c ,max(beginenddate_enddate) from Employeeeducation
where educationid is not null
group by employeeid,educationid ,[name])k
where k.employeeid=employee.employeeid

[wuzhibumian]

这个报消息 8155，级别 16，状态 2，第 1 行
没有为 'k' 的列 3 指定任何列。

[wuzhibumian]

消息 8155，级别 16，状态 2，第 1 行
没有为 'k' 的列 3 指定任何列。

[wuzhibumian]

是什么问题呀？

[AcHerat]

from (select employeeid ,educationid c ,max(beginenddate_enddate) as col from Employeeeducation

[AcHerat]

注意子查询的别名问题。

[快溜]

update employee set employee.educationid=k.educationid
from employee,(select employeeid ,educationid c ,max(beginenddate_enddate) from Employeeeducation
where educationid is not null
group by employeeid,educationid ,[name])k
where k.employeeid=employee.employeeid

[Mr_Nice]

[Quote=引用 4 楼 acherat 的回复:]

from (select employeeid ,educationid c ,max(beginenddate_enddate) as col from Employeeeducation
[/Quote]

+ 注意别名

[中国风]

update employee 
set employee.educationid=k.educationid
from (select employeeid ,educationid,max(beginenddate_enddate) from Employeeeducation
where educationid is not null
group by employeeid,educationid ,[name])k
where k.employeeid=employee.employeeid

educationid c --這里多了一個c別名

[wuzhibumian]

[Quote=引用 5 楼 acherat 的回复:]

注意子查询的别名问题。
[/Quote]
你确实是解决问题了，为什么要加这个，我用2000的时候没有这个问题呀，用2008有这个问题
as col 是给哪个取别名

[中国风]

[Quote=引用 9 楼 wuzhibumian 的回复:]

引用 5 楼 acherat 的回复:

注意子查询的别名问题。

你确实是解决问题了，为什么要加这个，我用2000的时候没有这个问题呀，用2008有这个问题
as col 是给哪个取别名
[/Quote]

update employee
set employee.educationid=k.educationid
from (select employeeid ,educationid,max(beginenddate_enddate) as c from Employeeeducation
where educationid is not null
group by employeeid,educationid ,[name])k
where k.employeeid=employee.employeeid

紅色的位置，別名你放錯了

[--小F--]

在更新的时候 子查询的得到的字段需要取别名。