title: SQL Inner Join On Null Values
body: <p>I have a Join </p>
  
  <pre><code>SELECT * FROM Y
  INNER JOIN X ON ISNULL(X.QID, 0) = ISNULL(y.QID, 0) 
  </code></pre>
  
  <p><code>Isnull</code> in a Join like this makes it slow.  It's like having a conditional Join.
  Is there any work around to something like this?
  I have a lot of records where <code>QID</code> is Null </p>
  
  <p>Anyone have a work around that doesn't entail modifying the data</p>