<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>

I can't find a solution to your precise problem that doesn't use a temporary table, but an alternate way of doing your query using a sub-select instead of a join is:
```
```
SELECT bars.* FROM bars WHERE bars.ID NOT IN (SELECT ID FROM foos)
```
```
Like the other posters I originally wrote:
```
```
SELECT * FROM foos WHERE foos.ID NOT IN (2, 4, 5, 6, 7)
```
```
but then I realised that this is producing the opposite to what you want.