SQL Server
UPDATE bh
SET bh.EndDate = t.EndDate -- SELECT *
FROM Tasks t INNER JOIN BilletHours bh
ON bh.Contract = t.Contract
AND bh.TaskNumber = t.TaskNumber
AND bh.Subtask = t.Subtask
WHERE t.Contract = '99'
AND t.TaskNumber IN ('IND','H','PTO')
MS-Access
UPDATE _Tbl_Comments_Import x INNER JOIN dbo_tbl_Comments_Import tci ON tci.ID = x.ID
SET x.CommentCategory = [tci].[CommentCategory]
, x.CommentReviewed = [tci].[CommentReviewed]
, x.Impactful = [tci].[Impactful]
, x.Scrubbed = [tci].[Scrubbed]
, x.Sentiment = [tci].[Sentiment]
, x.Key_Phrase_I = [tci].[Key_Phrase_I]
, x.Key_Phrase_II = [tci].[Key_Phrase_II]
, x.Key_Phrase_III = [tci].[Key_Phrase_III]
, x.Scrubbed_Comment = [tci].[Scrubbed_Comment];
UPDATE [*Tbl_Demographics_Import] x INNER JOIN dbo_tbl_Demographics_Import tci ON tci.respid = x.respid
SET x.USMarket = [tci].[USMarket]
WHERE x.USMarket = 0
