en.wikipedia.org/wiki/Set_operations_(SQL)#UNION_operator EXCEPT operator http://en.wikipedia.org/wiki/Set_operations_%28SQL%29 UNION SET OPERATIONS (SQL) set operations the Wikipedia entry Set Theory union http://en.wikipedia.org/wiki/Set_operations_(SQL) union SET OPERATIONS (SQL)