/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

0 vote114 views1 answer
Bootsrap textbox
C
0 vote114 views1 answer
KneesDev
C
1 vote130 views1 answer
LINEAR AND BINARY SEARCH
C
0 vote130 views1 answer
Cmd command to hide folder
C
0 vote136 views1 answer
Identifier bool is undefined in c
C
0 vote110 views1 answer
Check if pid exists c
C
0 vote118 views3 answers
Chevront de vlavier
C
0 vote112 views1 answer
Make a function makefile
C
0 vote121 views1 answer
How to italicise the text in html
C
2 votes111 views2 answers
Find only list directories
C

Share