/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

37 votes111 views2 answers
How to && in a while loop on c
C
0 vote139 views4 answers
VLOOKUP CHECK #N/A
C
0 vote140 views1 answer
Check if audio is muted python
C
-1 vote235 views2 answers
C program
C
0 vote144 views1 answer
Vim soft line break
C
0 vote76 views1 answer
What is stdin fd number
C
-1 vote158 views2 answers
Char in c
C
0 vote126 views1 answer
Modelform prefill with data
C
1 vote133 views1 answer
C fopen
C
0 vote179 views1 answer
Os.listdir to array
C

Share