/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 vote319 views2 answers
Get current used proxy windows 7
C
0 vote326 views1 answer
Answer to storing information in array
C
0 vote325 views1 answer
Object-fit not working
C
2 votes333 views2 answers
Measure time in c
C
0 vote311 views1 answer
Get int from user c
C
0 vote307 views1 answer
Vscode how to output in seperate consile
C
1 vote294 views1 answer
Default font for material ui
C
0 vote341 views1 answer
Two way communication between child and parent processes in C using pipes
C
2 votes338 views1 answer
How to find sum of two nums
C
7 votes350 views3 answers
How to sleep in c
C

Share