title: How to eliminate 'The multi-part identifier "" could not be bound' error?
body: <p>I have this query, it's supposed to return results of non validated accounts in a database, that were created after a certain date. I keep getting this error and I'm not sure how to eliminate it. Here is the query:</p>
  
  <pre><code>select count(*) (nolock)
  from dbo.[User]
  where ID is not null
  and UserStatusID!=2
  and CreateDateTime&gt;='5/1/2012'
  and not exists (select userid from dbo.UserValidation where dbo.[User].UserID=dbo.UserValidation.UserID)
  </code></pre>
  
  <p>It errors out on the "where dbo.[User].UserID=dbo.UserValidation.UserID" What am I doing wrong here?</p>