title: Is there a performance improvement when using JOIN vs a WHERE clause?
body: <p>Is there a performance difference (or any other reason) to use a JOIN instead of a WHERE clause as per the code examples below:</p>
  
  <p>ex1.</p>
  
  <pre><code>select *
  from table_1, table_2
  where table_1.id=table_2.id;
  </code></pre>
  
  <p>ex2.</p>
  
  <pre><code>select *
  from table_1
      join table_2 on
      table_1.id = table_2.id;
  </code></pre>