/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 vote143 views1 answer
Simple bootstrap form example
C
0 vote136 views1 answer
WAP to create Database using array of structure & display it in C
C
0 vote135 views1 answer
C memcpy array
C
1 vote213 views1 answer
C fractional sleep
C
0 vote136 views1 answer
Phpmyadmin export some errors have been detected
C
3 votes141 views1 answer
How to compareTo in java
C
0 vote145 views1 answer
Bp result system
C
2 votes138 views2 answers
How to delete virtual hard disk virtualbox
C
0 vote140 views1 answer
What is the use of malloc in c
C
0 vote131 views1 answer
Manasa loves maths solution IN C
C

Share