In this video I show you how to execute a Self Join in SQL and I discuss when you would use the Self Join. The demonstration uses SQL Server and SQL Server Management Studio (SSMS).
SQL Self Join | Quick Tips Episode #58
TABLE OF CONTENTS
0:00 - Intro
1:00 - Self Join Data Walkthrough
2:54 - Self Join Example with an Inner Join
5:25 - Other Type of Data with a Self Join
6:10 - Self Join Cleanup
7:44 - Self Join with a Left Join
9:55 - Handling Null in a Self Join
YOUTUBE NEWS UPDATES
http://www.youtube.com/user/sqltrainingonline
VISIT SQLTRAININGONLINE.COM FOR MORE VIDEO NEWS & TIPS
http://www.sqltrainingonline.com
SUBSCRIBE FOR OTHER SQL TIPS AND NEWS!
http://www.youtube.com/subscription_center?add_user=sqltrainingonline
SUBSCRIBE TO OUR EMAIL LIST!
http://www.sqltrainingonline.com
LET'S CONNECT!
LinkedIn: http://linkedin.com/in/joeyblue
SQLTrainingOnline: http://www.sqltrainingonline.com