Self join in sql server - Part 14

In this video we will learn about
1. Self Join - Joining a table with itself
2. Self Join is not a different type of join. It can be classified as Inner Self Join, Outer Self Join (Left, Right and Full), or Cross Self Join.

Text version of the video

Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help.

Slides

All SQL Server Text Articles

All SQL Server Slides

All Dot Net and SQL Server Tutorials in English

All Dot Net and SQL Server Tutorials in Arabic

[dirkmuller]

In preparation for the 70-761 exam, I found this to be an excellent source! Very clear structure with a high pedagogic value!

[OmarBela]

hands down THE BEST SQL TUTORIALS on youtube very consistent and clear

[ବିକାଶ_Biswal]

I learned most of the SQL functions through this tutorial.

Thanks for posting.

[elkhanhamet]

thank you sir, I watched two videos on this topic and couldn't grasp the whole idea behind it. But your explanation made it crystal clear, as usual. Thanks again sir and take care👍👍👍

[hervelobe]

Venkat, your explanations and videos are so well structured that they make the whole course look relatively easy!!! Many many thanks from Brussels

[krzysztofs]

GOD BLESS YOU! Have a nice day. These videos are wonderfull. You are great teacher.
Greetings from Poland!

[sofikulmallick]

This lectures help me a lot to understand the SQL.
I have started to apply it. Thank you very much.

[swativivek]

I want to thank for these superb tutorials. whenever I want to learn something on SQL I straight come to these tutorials. Thanks for sharing your knowledge with us.

[ga]

Thank you so much, I would like to say that you are the best one ever explained self join. many many thanks.

[TheDistractionStudio]

Was struggling to solve this on my own. Your video worked liked a charm. God bless you.

[timmytesla]

This is the best explanation of self join I have found. Thank you!

[edwoods]

Excellent video. I was wondering why we have to join a table to itself. Your explanation is very clear. Thank you so much.

[sumitjangir]

Your Explanation Clears my Concept of JOINS... Thanks a lot Sir.. and keep Updating Other Topics also..Thank you

[basava]

sir, ur voice is so good. I can sit and listen and learn whole day

[mukeshgarg]

Explained nicely in precise time.
Content presentation is awesome.
I enjoyed learning.
Thanku so much sir.

[avinashgaurav]

Simply Excellent!!! I don't understand why 51 dislikes.. for this beautiful and elegant explanation.

[pratibhachitrakar]

Your teaching method is wonderful. Thank you.

[hemalatha]

Thanks for all your tutorials on sql server.... Really good job and Great helpful....

[Tarikffm]

Great Job kudvenkat Best regards from Germany! Yo The way how you explain your Videos is amazing! 

[katsiarynanasovich]

Very clear and helpful explanation! Thanks a lot!