Outer join in subqueries?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Outer join in subqueries?

  1. #1
    Join Date
    Jan 2001
    Posts
    15

    Angry



    Can we do the outer join on subqueries?

    The following statement is not returning the results which I am expecting,
    am i missing some thing on outer join ??

    select a.col1,a.col2
    from
    tablename1 a, (select col1..... with few set operation like minus and union
    and returns one column which has same datatype of a.col1) b
    where
    a.col1 = b.col1 (+);







  2. #2
    Join Date
    Jan 2001
    Posts
    50
    hi'
    i couldnot your query properly but i tried the query with our emp and dept table
    like this
    ------------
    select a.deptno,a.ename from emp a,(select deptno from dept) b where a.deptno(+)=b.deptno;
    ---------------------
    it is running fine and giving the desired result
    Aniruddha Gupta

  3. #3
    Join Date
    Jan 2001
    Posts
    50
    hi,
    i couldnot get your query properly but i tried the query with our emp and dept table
    like this
    ------------
    select a.deptno,a.ename from emp a,(select deptno from dept) b where a.deptno(+)=b.deptno;
    ---------------------
    it is running fine and giving the desired result
    Aniruddha Gupta

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