Quick Search:
 mySQL: Opposite of UNION Jump to:  
Category: >> mySQL >> Opposite of UNION  

 next >>

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

SELECT table_1.* FROM table_1 
     LEFT JOIN table_2 ON table1.id=table_2.id
WHERE table_2.id IS NULL;

   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org