/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

1 vote318 views1 answer
Grepper VSCode Add On
C
0 vote307 views1 answer
How to reset all values of 2d vector to 0
C
0 vote311 views1 answer
Virtualbox how to move vmdk to another folder
C
2 votes332 views1 answer
Pygame draw transparent rectangle
C
0 vote305 views1 answer
Pendu langage c
C
-3 votes286 views2 answers
How to return a char array from a function in C
C
2 votes299 views5 answers
Pointers c
C
0 vote322 views1 answer
How to get out of function in c
C
32 votes414 views6 answers
Material ui icons
C
0 vote325 views1 answer
Subrayar elementos css
C

Share