/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

2 votes205 views1 answer
Signal function c
C
0 vote236 views1 answer
Arduino server read
C
0 vote200 views1 answer
Unox reclame harmonica tabs
C
0 vote235 views1 answer
Disable gnu++11 option
C
0 vote257 views1 answer
Cyrildewit laravel page view counter package.
C
0 vote189 views1 answer
C fscanf ignore commas
C
0 vote235 views1 answer
E sharm card jobkhozo.com
C
6 votes218 views2 answers
Atoi
C
1 vote237 views1 answer
How to make a hello world program in c
C
15 votes253 views2 answers
Boolean in c
C

Share