/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 vote139 views3 answers
C |= operator
C
0 vote140 views1 answer
Problem Statement Print the following output: \ Input Format IN Output Format \
C
0 vote157 views1 answer
Clipboard lib
C
0 vote141 views1 answer
Save text file c
C
0 vote140 views1 answer
How do you make a copy of a linked list in c
C
0 vote142 views1 answer
Suma de digitos
C
0 vote129 views1 answer
How to include multiline conditional inside template literal
C
4 votes140 views2 answers
ImportError: No module named 'skimage'
C
0 vote143 views1 answer
Android studio sdkmanager always accept
C
0 vote137 views1 answer
C copy 2 strings\
C

Share