db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendleton.de...@gmail.com>
Subject Re: Porting to standard SQL
Date Fri, 03 Feb 2012 01:38:25 GMT
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


Mime
View raw message