title: INNER JOIN Where Clause
body: <p>Is there a difference between doing something like</p>
  
  <pre><code>SELECT * 
  FROM table1 INNER JOIN table2 ON table2.ObjectId = table1.table2ObjectId 
  WHERE table2.Value = 'Foo'
  </code></pre>
  
  <p>vs </p>
  
  <pre><code>SELECT * 
  FROM table1 INNER JOIN table2 
  ON table2.ObjectId = table1.table2ObjectId AND table2.Value = 'Foo'
  </code></pre>