Snippet Name: Opposite of UNION
Description: This finds all rows in table1 with an id value that is not present in table2 (that is, all rows in table1 with no corresponding row in table2). This assumes that table_2.id is declared NOT NULL.
Comment: (none)
Language: SQL
Highlight Mode: MYSQL
Last Modified: February 26th, 2009
|
|