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
...
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)