On 02/02/2012 02:53 PM, TXVanguard wrote:
UPDATE T1 INNER JOIN T2 ON (T1.A= T2.A) SET T2.B = T1.B
Perhaps something like: update t2 set b = (select b from t1 where t1.a = t2.a) thanks, bryan
On 02/02/2012 02:53 PM, TXVanguard wrote:
UPDATE T1 INNER JOIN T2 ON (T1.A= T2.A) SET T2.B = T1.B
Perhaps something like: update t2 set b = (select b from t1 where t1.a = t2.a) thanks, bryan