title: Difference between JOIN and multitable select in PostgreSQL
body: <pre><code>CREATE TABLE a (aid int);
  CREATE TABLE b (bid int);
  INSERT INTO a VALUES (1), (2), (3);
  INSERT INTO b VALUES (2), (3), (4);
  </code></pre>
  
  <p>What would be the difference between</p>
  
  <p><code>SELECT * FROM a, b WHERE aid = bid;</code> and</p>
  
  <p><code>SELECT * FROM a JOIN b ON a.aid=b.bid;</code></p>
  
  <p>The result of <code>explain analyze</code> for both queries looks totally same.</p>