db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <Knut.Hat...@Sun.COM>
Subject Re: gentle reminder: buddy testers needed
Date Wed, 28 Apr 2010 11:07:38 GMT
On 04/28/10 12:49, Jayaram Subramanian wrote:
> Thanks for your comments Knut
> I verified that the error did go off when i tried something like this
> ResultSet rs=s.executeQuery("select t3.c from t1 join t2 using (a,c)
> join t3 using (c)");
> Also i was trying a subquery based scenario
> ResultSet rs=s.executeQuery("Select * from t1 where a in (select a
> from t2 join t1 using a)");

Hi Jayaram,

There is a typo in that last query. It should say "using (a)" (note the
parentheses around the column name). With that change, I believe it
should work with an IN subquery too.

Knut Anders

View raw message