-
HellO:
Is it possible to do full outer join in Oracle without using UNION
thanks,
-
Try
Select * from emp a, dept b where a.deptno = b.deptno (+);
Sam
Thanx
Sam
Life is a journey, not a destination!
-
Sorry, but that would be a right outer join.
The only way to do a full outer join in Oracles (pre-9i) is:
Select * from emp a, dept b where a.deptno = b.deptno (+)
UNION
Select * from emp a, dept b where a.deptno(+) = b.deptno
;
So, to answer your question - No, the union is the only way.
Sorry,
- Chris
-
Thank you!
just wanted to clarify on that.
-
Daaa!!! where was I? Chris good correction.
Thanx,
Sam
Thanx
Sam
Life is a journey, not a destination!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|