更新字段出错
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
[解决办法]
from (select employeeid ,educationid c ,max(beginenddate_enddate) as col from Employeeeducation
[解决办法]
