title: Join predicate order
body: <p>I'm always be amused and confused(at same time) whenever I have been to asked prepare and run <code>Join</code> query on Sql Console.</p>
  
  <p>And the cause of most confusion is mainly based upon the fact whether/or not the <strong>ordering</strong> of join predicate hold any importances in Join results.</p>
  
  <p>Example.  </p>
  
  <pre><code>SELECT  "zones"."name", "ip_addresses".*
      FROM  "ip_addresses"
      INNER JOIN  "zones" ON "zones"."id" = "ip_addresses"."zone_id"
      WHERE  "ip_addresses"."resporg_accnt_id" = 1
        AND  "zones"."name" = 'us-central1'
      LIMIT  1; 
  </code></pre>
  
  <p>Given the sql query, the Join predicate look like this.</p>
  
  <p><code>... INNER JOIN "zones" ON "zones"."id" = "ip_addresses"."zone_id" WHERE "ip_addresses"."resporg_accnt_id"</code></p>
  
  <p>Now, would it make any difference in term of <strong>performance</strong> of Join as well as the authenticity of the obtained result. If happen to change the predicate to look like this</p>
  
  <p><code>... INNER JOIN "zones" ON  "ip_addresses"."zone_id" = "zones"."id" WHERE "ip_addresses"."resporg_accnt_id"</code></p>