title: Can we perform nonequi join with outer join?
body: <p>Can we perform outer join with inquality operators. 
  When I tried I got the result for right outer join but it's not working for left outer join.</p>
  
  <pre><code>SELECT EMP.ENAME,EMP.SALARY,SALG.SALARY_GRADE
  FROM EMPLOYEE EMP , SALARY_GRADES SALG
  WHERE EMP.SAL BETWEEN SALG.FROM_RANGE(+) AND SALG.TO_RANGE
  </code></pre>
  
  <p>Above query is generating the result as inner join where as below query is working fine.</p>
  
  <pre><code>SELECT EMP.ENAME,EMP.SALARY,SALG.SALARY_GRADE
  FROM EMPLOYEE EMP , SALARY_GRADES SALG
  WHERE EMP.SAL(+) BETWEEN SALG.FROM_RANGE AND SALG.TO_RANGE
  </code></pre>
  
  <p>I meant to say that right outer join is working fine but not left outer join.</p>