title: Select From Multi-Value List with Where Clause
body: <p>I'm trying to select all <code>Projects</code> which have <code>Employees</code> who are <code>AtWork</code>.</p>
  
  <pre><code>Projects:
  ProjName    |    EmpOnProj
  --------------------------
  Alpha       |    1, 2, 3
  Beta        |    1, 3
  
  Employees:
  EmpID       |   EmpName    |   AtWork
  -------------------------------------
  1           |   John       |   TRUE
  2           |   Mark       |   FALSE
  3           |   Mary       |   TRUE
  </code></pre>
  
  <p>I need to output all projects which could currently be worked on; ie, I need to show <code>Beta</code> because the employees working on Beta are at work.</p>
  
  <p>Currently I cannot say "ALL EMPLOYEES MUST BE AT WORK" only the following:</p>
  
  <pre><code>SELECT ProjName FROM Projects INNER JOIN 
  Employees ON EmpOnProj.Value = EmpID
  WHERE AtWork = true
  GROUP BY ProjName
  </code></pre>
  
  <p>which returns both, as it sees one correct employee and displays the project.</p>