title: Convert Oracle legacy outer join to Ansi SQL
body: <p>I have a complex non ansi query and I need to convert in ansi query.</p>
  
  <p>so I will take a small example to describe my problem</p>
  
  <p>input query</p>
  
  <pre><code> SELECT a.name,
           a.empno,
           b.loc,
           c.inr
      FROM a,
           b,
           c
     WHERE a.deptno = b.deptno(+)
       AND b.empno(+) = 190
       a.deptno = c.deptno(+)
       AND c.empno(+) = 190;
  </code></pre>
  
  <p>Thanks in advance</p>