/C/Joins in update query

Joins in update query

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 ...

2

Source: stackoverflow.com

Joins in update query

update a
join b 
on a.a_id=b.b_id 
set b.is_active = 1 
where ....;

0

Similar codes

7 votes149 views2 answers
How to press enter in selenium
C
13 votes181 views5 answers
Pandas index
C
3 votes208 views1 answer
C printing char pointer
C
0 vote160 views1 answer
Left me on read
C
0 vote193 views2 answers
Fgets remove newline
C
1 vote196 views1 answer
Keyboard shortcut for opening a file in mac
C
0 vote183 views1 answer
Creation of a thread
C
-22 votes185 views9 answers
7zip
C
0 vote164 views1 answer
Len of str vbs
C
2 votes179 views2 answers
Json reading in php with key
C

Share