Hi, Could i have your thoughts and more ideas for testing the "using" functionality..
With Regards Jayaram On Wed, Apr 28, 2010 at 10:31 PM, Jayaram Subramanian <[email protected]> wrote: > Hi, > I tried the following view based scenario of the using clause and > found the code flow through without issues > s.execute("create table t1(a int, b int, c int)"); > s.execute("create table t2(a int, b int, c int)"); > s.execute("create table t3(a int, b varchar(5), c int)"); > s.execute("create view aview(a,b) as select a,t3.c from t1 join t3 > using (c,a)"); > s.execute("insert into t1 values (1,2,3),(2,3,4),(4,4,4)"); > s.execute("insert into t2 values (1,2,3),(2,3,4),(5,5,5)"); > s.execute("insert into t3 values " + > "(2,'abc',8),(4,'def',10),(null,null,null)"); > ResultSet rs=s.executeQuery("select * from aview join t1 using (b)"); > > With Regards > Jayaram >
