title: SQL Server LEFT JOIN and WHERE clause
body: <p>Here is my code</p>
  
  <pre><code>SELECT ID, Name, Phone 
  FROM Table1 
  LEFT JOIN Table2 ON Table1.ID = Table2.ID
  WHERE Table1.ID = 12 AND Table2.IsDefault = 1
  </code></pre>
  
  <p>The problem happens when Table2 is null, so, the query returns nothing. </p>
  
  <p>How do I leave the last part of the query <code>AND Table2.IsDefault = 1</code> optional?</p>
  
  <p>I've tried to short circuit the query using <code>OR</code> but I've found out that it works different than C#</p>