/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

21 votes140 views6 answers
Material UI install
C
0 vote140 views1 answer
Regex to match any character being repeated more than 10 times
C
0 vote153 views1 answer
How to sort an int array in c
C
0 vote88 views1 answer
Lxc Failed to load config for
C
0 vote158 views1 answer
Mitch mcconnell
C
11 votes178 views6 answers
Malloc in c
C
1 vote140 views1 answer
Stop Redis in Ubuntu WSL
C
6 votes161 views6 answers
MongoDb
C
1 vote151 views1 answer
Difference between malloc and calloc and realloc
C
0 vote213 views1 answer
ESP32 timerBegin(0, cpuClock, true);
C

Share