/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 vote118 views1 answer
$ei = $_GET['id']; $na = $_GET['name']; $em = $_GET['email'];
C
1 vote121 views1 answer
Connect servo to arduino
C
0 vote113 views1 answer
C file struct
C
0 vote122 views1 answer
How to reset all values of 2d vector to 0
C
0 vote117 views1 answer
String insertion into another string
C
0 vote115 views1 answer
How to find folders from a c program
C
18 votes115 views9 answers
While loop
C
-22 votes124 views9 answers
7zip
C
0 vote119 views1 answer
MyFgets in c
C
0 vote121 views1 answer
Command line coursera
C

Share