title: MySQL - Select from a list of numbers those without a counterpart in the id field of a table
body: <p>I have a list of numbers, say {2,4,5,6,7}
  I have a table, foos, with foos.ID, including say, {1,2,3,4,8,9}</p>
  
  <p>Id like to take my list of numbers, and find those without a counterpart in the ID field of my table.</p>
  
  <p>One way to achieve this would be to create a table bars, loaded with {2,4,5,6,7} in the ID field.
  Then, I would do </p>
  
  <pre>
  SELECT bars.* FROM bars LEFT JOIN foos ON bars.ID = foos.ID WHERE foos.ID IS NULL
  </pre>
  
  <p>However, I'd like to accomplish this sans temp table. </p>
  
  <p>Anyone have any input on how it might happen?</p>