Developer's Edge
get | set | share
Saturday, April 25, 2020
Update Record with INNER JOIN SQL Server
General syntax for updating table by getting information from multiple tables..
UPDATE
TableA
SET
Col2 ..,
...
FROM
TableA AS A
INNER JOIN
TableB AS B ON B.Col1 = A.Col1
...
WHERE
...
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment