title: SQL join and filtering
body: <p>Does these two solutions give the same result ?</p>
  <pre><code>SELECT *
  FROM Orders
  LEFT JOIN OrderLines ON OrderLines.OrderID=Orders.ID 
      AND Orders.ID = 12345
  </code></pre>
  <hr />
  <pre><code>select orderID
  into #temp
  from OrderLines
  where orderID=12345
  
  SELECT *
      FROM Orders
      LEFT JOIN #temp t ON t.OrderID=Orders.ID 
          
  </code></pre>
  <p>I would like to use the temp tables for performance</p>