db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From TXVanguard <brett.den...@lmco.com>
Subject Re: Porting to standard SQL
Date Mon, 06 Feb 2012 15:43:57 GMT


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.


Mime
View raw message