title: What is difference between ANSI and non-ANSI joins, and which do you recommend?
body: <p>I have come across many websites to find the answer about which one is better, ANSI or non- ANSI syntax. What is the difference between these two queries?</p>
  
  <pre><code>select a.name,a.empno,b.loc
  from tab a, tab b
  where a.deptno=b.deptno(+);
  </code></pre>
  
  <p>and:</p>
  
  <pre><code>select a.name,a.empno,b.loc
  from tab a 
  left outer join tab b on a.deptno=b.deptno;
  </code></pre>
  
  <p>The result is same in both the cases. The second query is also longer. Which one is better?</p>
  
  <p>suppose if we have added another table Salgrade in the above query based on what conditions we need to join them?? ..
  can any one assume one table and give me explanation</p>