Quite Samples of “NOT IN” Sql Statement

You want to select field of first table that not contain in the second table. You can write SQL statement like this….

SELECT a FROM x WHERE x.b NOT IN (SELECT b FROM y);

Reference: http://stackoverflow.com/questions/232935/sql-query-where-field-does-not-contain-x