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.

Thanks,
-- 
Knut Anders

Mime
View raw message