/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 vote199 views1 answer
Vbl share price
C
0 vote215 views1 answer
How to change background color in c programming
C
4 votes130 views2 answers
Remove character from string c
C
0 vote253 views2 answers
Cannot convert from 'int' to 'string' [Api]
C
1 vote232 views2 answers
Sum of arrays
C
1 vote185 views1 answer
Grep find and replace
C
1 vote189 views1 answer
How to auto run something on cmd
C
0 vote200 views1 answer
Incompatible implicit declaration of built-in function 'printf'
C
0 vote198 views1 answer
Pointer parameter where to put the asterix in C?
C
0 vote198 views1 answer
C change value of const
C

Share