title: Create an inline SQL table on the fly (for an excluding left join)
body: <p>Let's assume the following:</p>
  <p>Table A</p>
  <pre><code>id | value
  ----------
  1   | red
  2   | orange
  5   | yellow
  10  | green
  11  | blue
  12  | indigo
  20  | violet
  </code></pre>
  <p>I have a list of id's (<code>10, 11, 12, 13, 14</code>) that can be used to look up id's in this table.  This list of id's is generated in my frontend.</p>
  <p>Using purely SQL, I need to select the id's from this list (<code>10, 11, 12, 13, 14</code>) that do not have entries in Table A (joining on the 'id' column).  The result should be the resultset of id's <code>13</code> and <code>14</code>.</p>
  <p>How can I accomplish this using only SQL?  (Also, I'd like to avoid using a stored procedure if possible)</p>
  <p>The only approach I can think of is something that would create an inline SQL table on the fly to temporarily hold my list of id's.  However, I have no idea how to do this.  Is this possible?  Is there a better way?</p>
  <p>Thanks! :)</p>