Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

how to add where command in update comand with joins

UPDATE A
SET foo = B.bar
FROM TableA A
JOIN TableB B
    ON A.col1 = B.colx
WHERE ...
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #add #command #update #comand #joins
ADD COMMENT
Topic
Name
8+9 =