| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
