title: SQL Server  2005/2008 : find row values that exist and list that don't in my in select column condition IN()
body: <p>I have a single table that contain columns:</p>
  
  <pre><code>UserID, EmployeeID, BadgeType, HiredDate, TermDate
  </code></pre>
  
  <p>Now I need to find <code>userID</code> that are with <code>(gbro, qunro, 1utny, ybeiot, 4ybey)</code></p>
  
  <p>The 3 users (<code>gbro, qunro, 1utny</code>) exist so it is listed with respective its column info.</p>
  
  <p>What if <code>ybeiot, 4ybey</code> does not exist AT ALL but still I want them listed in a separate table still but with a message that PRINTS: <code>User that does not exist: ybeiot;4ybey</code></p>
  
  <p>Help, been finding way how to do this.</p>
  
  <p>I tried <code>JOIN</code> (all the joins) but it does not result to what I wanted.</p>