TOP

SQL update join

UPDATE B
SET
B.[LAST_RECRUIT_PRINT_DATE] = A.[LAST_RECRUIT_PRINT_DATE],
B.[LAST_RECRUIT_ONLINE_DATE] = A.[LAST_RECRUIT_ONLINE_DATE]
FROM
[Web_HearstSalesForce].[dbo].[VW_AccountsRecruit_320] A,
[Web_HearstSalesForce].[dbo].[Accounts] B
WHERE A.AccountNumber=B.AccountNumber

Comments are closed.