Home » Developer & Programmer » JDeveloper, Java & XML » Outer Join Syntax using Java/JDBC
Outer Join Syntax using Java/JDBC [message #92036] Fri, 13 February 2004 12:23
mb
Messages: 51
Registered: March 2001
Member
I'm using 8i database...

SQL> select * from one;
C1         C2
---------- ----------
A          1
B

SQL> select * from two;

C1         C2
---------- ----------
A          1

Desired output:

SQL> select t1.c1, t1.c2, t2.c1 tc1, t2.c2 tc2
  2  from one t1, two t2
  3  where t1.c1 = t2.c1(+);

C1         C2         TC1        TC2
---------- ---------- ---------- ----------
A          1          A          1
B

When I try the outer join stmt on the app code using java, it didn't work.  Any idea why?

Thanks.

 
Previous Topic: Assigning XML Element to a JSP Variable
Next Topic: Exception in thread "main" java.lang.NoClassDefFoundError
Goto Forum:
  


Current Time: Fri Mar 29 06:35:02 CDT 2024