Below is the query:
  UPDATE  (select * from [HR_DEV_DM].[CFQ_TEST].CFQ_Referrals as CFRQ LEFT JOIN [HR_DEV_DM].[CFQ_TEST].t_Chg_Rsns as CHGRSNS ON CFRQ.RecChangeID = CHGRSNS.Chg_ReasID) INNER JOIN [HR_DEV_DM].[CFQ_TEST].t_Qt_Typs ON [HR_DEV_DM].[CFQ_TEST].CFQ_Referrals.QuoteType = [HR_DEV_DM].[CFQ_TEST].t_Qt_Typs.Qt_Typ  SET [HR_DEV_DM].[CFQ_TEST].CFQ_Referrals.RecKey = dbo.BuildRecordKey([HR_DEV_DM].[CFQ_TEST].CFQ_Referrals.[ReferralCode], [HR_DEV_DM].[CFQ_TEST].CFQ_Referrals.[RetentionID], [HR_DEV_DM].[CFQ_TEST].CFQ_Referrals.[ClientFName],[HR_DEV_DM].[CFQ_TEST].CFQ_Referrals.[ClientLName],  IIf([HR_DEV_DM].[CFQ_TEST].t_Qt_Typs.Qt_Grp='MOAT',[HR_DEV_DM].[CFQ_TEST].CFQ_Referrals.[QuotePolicyType],[HR_DEV_DM].[CFQ_TEST].CFQ_Referrals.[ClientZip]), [HR_DEV_DM].[CFQ_TEST].[CFQ_Referrals].[QuoteType]) WHERE ((([HR_DEV_DM].[CFQ_TEST].CFQ_Referrals.RecProcessed)=0)  A ...

Go to the complete details ...