Update from a Select

Update from a Select

I know many people won't find this new, but it's the first time I've had to do it today.

I needed to update one table, from another table, and here's how I did it: -

UPDATE C

SET C.Phone = O.[Tel No],

C.Fax = O.[Fax]

FROM output$ O

JOIN Contacts C ON C.MemberId = O.MemberId