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 18:22:05 GMT

Rick Hillegas-3 wrote:
> This means that more than 1 row is returned by the subquery. That, in 
> turn, suggests that the query, which succeeds for you on another 
> database, may not be behaving in a predictable way there. Since more 
> than one row qualifies to drive the update, which row do you want? Is 
> there some other restriction which you can put in the subquery to 
> guarantee that you get one, predictable row?
> Hope this helps,
> -Rick

I wonder why this doesn't cause a problem for Access?

View this message in context: http://old.nabble.com/Porting-to-standard-SQL-tp33253800p33273439.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.

View raw message