/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 vote391 views1 answer
Roll binary c
C
-1 vote373 views1 answer
Free array in c
C
0 vote389 views1 answer
Mediawiki upload size
C
1 vote364 views1 answer
What is system function in c
C
0 vote410 views1 answer
Clarity ppm jasper domain commands
C
0 vote459 views1 answer
Rpobleme valgrind
C
0 vote351 views1 answer
How to transfer textbox fro string to integer vb.net
C
1 vote398 views1 answer
Error: 'endl' was not declared in this scope
C
2 votes374 views1 answer
Arduino digital input pins
C
0 vote364 views1 answer
Double array c++
C

Share