Intersect, Except, Union, All and Any

This article examines some of the little used T-SQL items function and see if they work for you

reade more

http://www.sqlservercentral.com/articles/T-SQL/67545/

cheers
Samitha