Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

JOINs and UNIONs - How Do I Know When to Use a JOIN or UNION

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
31,808
Loading...
Alert icon
Sign in or sign up now!
Alert icon
Ratings have been disabled for this video.

Uploaded by on Jul 3, 2007

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

Category:

Howto & Style

Tags:

License:

Standard YouTube License

All Comments

Adding comments has been disabled for this video.

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more