If loadfacttable is unique by 'c' you might consider...
Code:UPDATE ( SELECT f.a, f.b, l.a new_a, l.b new_b FROM loadfacttable l, facttable f WHERE f.c = l.c) SET a = new_a, b = new_b;
|
Results 1 to 10 of 26
Thread: update using subqueryThreaded View
|
Click Here to Expand Forum to Full Width |