I need to update a field in a table based on a field from another table. I am only familiar with using Joins with a Select statement so I know my syntext is wrong... can someone please show me the correct syntext.
Update HanStores T SET T.AuditCompany = 'WRP'
Left outer join HanAR T1 On T.StoreNum = T1.StoreID
Where T1.Auditor LIKE 'Carl%'