Here’s how to update one table by selecting the values from another:
UPDATE C
SET C.Phone = O.[Tel],
C.Fax = O.[Fax]
FROM output$ O
JOIN Contacts C
ON C.MemberId = O.MemberId
Maybe this saves someone time..
Tutorials and Codesnippets about C#, ASP.NET
0 comments ↓
There are no comments yet...Kick things off by filling out the form below.
Leave a Comment