sql嵌套批量更新

嵌套批量更新

UPDATE CheLiang SET lineName = t.linename
FROM TeamJiHua t ,CheLiang tc WHERE t.id = tc.teamid