title: OR Clause in SQL Server LEFT JOIN causing high logical reads
body: <p>How can I rewrite the below query by eliminating the OR clause</p>
  
  <pre><code>SELECT T1.Name, T1.Value-T2.value as value 
  FROM TABLE1 T1 LEFT JOIN TABLE2 T2 ON T2.ID=T1.ID OR T2.OLD_ID=T1.ID
  </code></pre>