====== Microsoft - Microsoft SQL Server - SQL - Tables - Update Table with join to another Table ======

<code sql>
CREATE procedure Reset_Failed_Processing_Vendor_Records
as
update  ztV set 
ztV.zReadyForReview = null, 
ztV.zReadyForReviewOn = null, 
ztV.zConfirmed = null, 
ztV.zConfirmedOn = null, 
ztV.zConfirmedBy= null
FROM    dbo.ztVenDedup as ztV
INNER JOIN dbo.Vendor_Failure_Groups as Ven
on Ven.partner1=ztV.PARTNER 
and Ven.zCheckWithinGroup=ztV.zCheckWithinGroup
</code>

----

<code sql>
update  ztV set 
ztV.zField05 = Ven.Updated_Value
FROM    dbo.ztStructureCleansing as ztV
INNER JOIN dbo.Address_Cleansing_Fix2 as Ven
on Ven.Keyfield=ztV.Keyfield
where Ven.Field_to_be_updated  = 'zfield05'
and ztV.zObject = Ven.[Source]
</code>