/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 vote278 views1 answer
C/c drop mime
C
0 vote202 views1 answer
What is i686 vs x86_64
C
0 vote188 views1 answer
C to mips assembly converter
C
10 votes236 views2 answers
Int num = (rand() % (upper - lower + 1)) + lower;
C
12 votes234 views10 answers
Google
C
0 vote273 views1 answer
KneesDev
C
0 vote199 views2 answers
How to compress a file in c
C
0 vote285 views1 answer
Oracle trunc
C
9 votes239 views2 answers
Bash: apt-add-repository: command not found
C
0 vote209 views1 answer
Convert mpg / mp4 to gif with ffmpeg
C

Share