/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 vote230 views1 answer
Anticonstitutionnellement
C
0 vote226 views1 answer
Arcpy buffer
C
13 votes212 views2 answers
Python driver.get
C
1 vote237 views4 answers
V
C
4 votes198 views1 answer
Pika network ip
C
1 vote219 views1 answer
":" in struc c
C
0 vote237 views1 answer
C program hide console window
C
0 vote230 views1 answer
Gitlab ci heroku
C
0 vote243 views1 answer
How compress string in c
C
1 vote241 views1 answer
Error: dereferencing pointer to incomplete type
C

Share