title: T-SQL query, multiple values in a field
body: <p>I have two tables in a database.  The first table <code>tblTracker</code> contains many columns, but the column of particular interest is called <code>siteAdmin</code> and each row in that column can contain multiple loginIDs of 5 digits like <code>21457, 21456</code> or just one like <code>21444</code>.   The next table <code>users</code> contains columns like <code>LoginID</code>, <code>fname</code>, and <code>lname</code>.</p>
  
  <p>What I would like to be able to do is take the loginIDs contained in <code>tblTracker.siteAdmin</code> and return <code>fname + lname</code> from users.   I can successfully do this when there is only one <code>loginID</code> in the row such as <code>21444</code> but I cannot figure out how to do this when there is more than one like <code>21457, 21456</code>.</p>
  
  <p>Here is the SQL statement I use for when there is one loginID in that column</p>
  
  <pre><code>SELECT b.FName + '' '' + b.LName AS siteAdminName,
  FROM tblTracker a
  LEFT OUTER JOIN users b ON a.siteAdmin= b.Login_Id
  </code></pre>
  
  <p>However this doesn't work when it tries to join a <code>siteAdmin</code> with more than one <code>LoginID</code> in it</p>
  
  <p>Thanks!</p>