/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 vote356 views1 answer
Right side of div
C
8 votes340 views2 answers
Print bool c
C
0 vote317 views1 answer
+ *********************
C
1 vote315 views1 answer
Divide and conquer program in c
C
-1 vote340 views2 answers
C tutorials
C
0 vote312 views1 answer
UTC offset upper limit
C
0 vote344 views1 answer
Absolute value of intel intrinsic
C
0 vote321 views1 answer
Fibonacci program c pthread
C
5 votes325 views1 answer
Type change in c
C
2 votes324 views1 answer
C union in struct
C

Share