CREATE TEMPORARY TABLE foo ( bar INT NOT NULL ); INSERT INTO foo (bar) VALUES (1),(2),(4),(5); SELECT foo.bar FROM foo LEFT OUTER JOIN num_table ON (foo.bar = num_table.num) WHERE num_table.primary_key_column IS NULL ;