Bryan Pendleton-3 wrote: > > > Perhaps something like: > > update t2 set b = (select b from t1 where t1.a = t2.a) > >
I tried your suggestion, but now I get the error message: "Scalar subquery is only allowed to return a single row." Any other suggestions? -- View this message in context: http://old.nabble.com/Porting-to-standard-SQL-tp33253800p33272288.html Sent from the Apache Derby Users mailing list archive at Nabble.com.