Re: Porting to standard SQL

[Bryan Pendleton]

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