title: Which values are missing in SQL from a list?
body: <p>I have a list of values, say <code>1,2,3,4,5,6</code>. I have a SQL table with a field storing these values but only three rows, say, <code>2,4,5</code>. What sort of query will return three rows <code>1,3,6</code> for me? (storing all six in another table and left join'ing is cheating.)</p>