title: SQL JOIN where to place the WHERE condition?
body: <p>I have two following examples.</p>
  
  <p><strong>1. Example (WHERE)</strong></p>
  
  <pre><code>SELECT 1
    FROM table1 t1
    JOIN table2 t2 ON t1.id = t2.id
   WHERE t2.field = true
  </code></pre>
  
  <p><strong>2. Example (JOIN AND)</strong></p>
  
  <pre><code>SELECT 1
    FROM table1 t1
    JOIN table2 t2 ON t1.id = t2.id AND t2.field = true
  </code></pre>
  
  <p>What is the faster way in terms of performance? What do you prefer?</p>