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.
