DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: SQL query (full outer join)

  1. #1
    Join Date
    Aug 2000
    Posts
    194
    HellO:

    Is it possible to do full outer join in Oracle without using UNION

    thanks,



  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Try

    Select * from emp a, dept b where a.deptno = b.deptno (+);

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    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


  4. #4
    Join Date
    Aug 2000
    Posts
    194
    Thank you!

    just wanted to clarify on that.

  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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
  •  


Click Here to Expand Forum to Full Width