/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

3 votes334 views1 answer
Error: 'for' loop initial declarations are only allowed in C99 or C11 mode
C
0 vote308 views1 answer
Code for qsort in C with swap
C
8 votes304 views1 answer
Arduino millis
C
1 vote297 views1 answer
Msdos
C
0 vote291 views1 answer
Mark rober
C
0 vote338 views1 answer
Multiplicationin c
C
0 vote286 views1 answer
National festivals of india in hindi
C
0 vote295 views1 answer
Debian9 remove pack
C
0 vote308 views1 answer
How to reset all values of 2d vector to 0
C
0 vote301 views1 answer
C program to find area of circle
C

Share