UPDATE target_table AS tgt SET campaign_name = src.campaign_name, line_of_business = src.Campaign_Line_Of_Business FROM ( SELECT A.project_id , A.campaign_id , A.run_id , B.Campaign_Line_Of_Business, B.campaign_name FROM target_table A left JOIN src_table B ON (A.Project_id = B.Project_id AND A.Campaign_id = B.Campaign_id AND A.Run_id = B.Run_id) GROUP BY 1, 2, 3, 4, 5 ) src WHERE (tgt.project_id = src.project_id and […]