JOINs and UNIONs - How Do I Know When to Use a JOIN or UNION
Visit LearnItFirst, our new channel with over 100 videos!
---------------------------------------------------------------------------------
So many newbies to Transact-SQL have difficulties determing when to use a UNION or a JOIN to satisy their query. This video teaches you some guidelines to help you quickly and easily identify whether your query will likely need to become a JOIN or UNION. Disclaimer: these are just guidelines and they will not work in every situation but they are applicable for most SQL developers most of the time.
Author: Scott Whigham
Versions: SQL Server 2008, SQL Server 2005, SQL Server 2000/7.0