/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 vote160 views1 answer
Arduino serial read write structure
C
0 vote186 views1 answer
'Process: 12142 ExecStartPre=/usr/sbin/nginx -t -q -g daemon on; master_process on; (code=exited, status=1/FAILURE)'
C
0 vote166 views1 answer
C program boilerplate code
C
0 vote157 views1 answer
Symmetrical matrix in C
C
0 vote178 views1 answer
Malloc basics
C
1 vote234 views1 answer
How to checkout branch from commit id
C
0 vote157 views1 answer
::template
C
0 vote205 views1 answer
Conditional compilation in c
C
5 votes168 views1 answer
Matplotlib plot line style
C
0 vote165 views1 answer
How to change file permissions in C language
C

Share