多字段更新语法,供忘记时参考
UPDATE DW_PR_TASK T
SET (T.DW_TEAM, T.DW_TEAM_ID) =
(SELECT TEAM_NAME, PID
FROM (SELECT TE.D, TEAM.TEAM_NAME, TEAM.PID
FROM TEST_DW_LW TE
LEFT JOIN DW_CP_TEAM TEAM
ON TE.A = TEAM.TEAM_NAME
WHERE NOT EXISTS (SELECT 1
FROM DW_PR_TASK T
WHERE T.RESOURCE_NAME = TE.D
AND T.PLAN_MONTH = '2015-03'
AND T.DW_TEAM = TE.A)) R
WHERE R.D = T.RESOURCE_NAME)
WHERE EXISTS (SELECT 1
FROM (SELECT TE.D, TEAM.TEAM_NAME, TEAM.PID
FROM TEST_DW_LW TE
LEFT JOIN DW_CP_TEAM TEAM
ON TE.A = TEAM.TEAM_NAME
WHERE NOT EXISTS (SELECT 1
FROM DW_PR_TASK T
WHERE T.RESOURCE_NAME = TE.D
AND T.PLAN_MONTH = '2015-03'
AND T.DW_TEAM = TE.A)) R
WHERE R.D = T.RESOURCE_NAME
AND T.PLAN_MONTH = '2015-03')