вторник, 7 декабря 2010 г.

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 Outputs O
JOIN Contacts C
ON C.MemberId = O.MemberId

Комментариев нет: