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
