SQL Self Join | Quick Tips Ep58

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
UA-cam NEWS UPDATES
/ sqltrainingonline
VISIT SQLTRAININGONLINE.COM FOR MORE VIDEO NEWS & TIPS
www.sqltrainingonline.com
SUBSCRIBE FOR OTHER SQL TIPS AND NEWS!
ua-cam.com/users/subscription_c...
SUBSCRIBE TO OUR EMAIL LIST!
www.sqltrainingonline.com
LET'S CONNECT!
LinkedIn: / joeyblue
SQLTrainingOnline: www.sqltrainingonline.com

[@andyknright]

You are a God! The best explained videos. I dont know what other tutorials are talking about. You just simple cut to the chase and on point!!!

[@ranasoleimani4650]

very good video, so good explanation about the joins.

[@funtik_777]

Amazing video, easy to understand the concept of self join. Thanks

[@Attilaohuno]

Thank you, very helpful!

[@svdfxd]

Great video....simple explanation

[@tonyjinca]

Thank you SIR!

[@sagarmoret-2862]

thanks you sir.
really really appreciate.
thanks from india and everybody who wants to learn

[@smgt90]

great video!

[@radiagulzan]

thank you !

[@luizetulio4888]

Hi Joey great video
Is it possible to have a many to many relationship in self join tables, for example if a employee has 2 or more managers

[@user-rq5uh7iq1d]

Suppose we have 3 server, in this servers all the databases and tables name can we retrieve ?

[@sewanusunday9605]

Thanks

[@ethiotube4805]

Do you create employee-I’d as primary key and managerid as foreign key? If so How these number would be not unique?

[@iwuchukwunwabueze7197]

Thanks for this, is there a video for categorical data?

[@maitreyeekarmakar6429]

Couldn't understand is null part...