/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 votes256 views1 answer
Run program without main method using macro
C
3 votes250 views3 answers
Int to float c
C
23 votes248 views3 answers
Picasso
C
2 votes266 views1 answer
Run a command in cmd with c
C
7 votes268 views6 answers
Reverse string in c
C
0 vote248 views1 answer
My name is c
C
0 vote258 views1 answer
Execution time of c program
C
1 vote254 views3 answers
Prime number in c
C
0 vote252 views1 answer
Declaring multiple pointers in one line c
C
3 votes203 views1 answer
Scala list
C

Share