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
ON C.MemberId = O.MemberId
Комментариев нет:
Отправить комментарий