Joins in sql server - Part 12

In this video we will learn about
1. The different types of Joins in sql server
2. Cross Join
3. Inner Join
4. Outer Join -- Left , Right and Full Outer 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

[VishnuMenonthisisrealme]

At last... Thanks to your video I'm all clear in joins

[FusionArcs]

just awesome. It helped me a lot in examinations. Thank you for providing such an easy lessons to difficult topics with examples.

[omkargodse]

Nicely explained! This is the number 1 video on join on YouTube.

[nirajsahni]

Sir u r far better than my college RDBMS teacher. I will recommend him to watch ur videos☺

[nidhimishra]

So lucky to have found this channel, it has literally everything there is to learn in SQL.. and so well taught. So neatly arranged. And its FREE.! Its 100 times better than any paid courses. Thanks lot of creating these lectures!

[htinlin]

Thank you very much that you share your knowledge sql
Now i am learning your sql vedio lecture and i can't watch your Joins in sql server - Part 12 according to some errors. Please could you upload your Joins in sql server - Part 12 again.

[mephandr]

Great explanation, thank you. One scenario is missing. How do you get only the non matching records from left and right tables?

[saadabdulllah]

I have found a exactly same example in an interview written test.

[webleydevelopment]

If this doesn't teach me what I want to know, Im going to throw my SQL Server out of the window! :)

[marlonsubuyu]

In case you don't have the rows from this tutorial, here you go:

Use Sample1
GO
Create table tblEmployee (
id int primary key NOT NULL,
[name] varchar(50) NOT NULL,
gender varchar(15) NOT NULL,
salary int NOT NULL,
DepartmentId int,
)

ALTER TABLE tblEmployee ADD CONSTRAINT FK_tblEmployee_DepartmentId
Foreign Key(DepartmentId) REFERENCES tblDepartment(id)

Create table tblDepartment (
id int primary key NOT NULL,
DepartmentName varchar(50) NOT NULL,
[Location] varchar(50) NOT NULL,
DepartmentHead varchar(50) NOT NULL,
)

Insert into tblDepartment values(1, 'IT', 'London', 'Rick')
Insert into tblDepartment values(2, 'Payroll', 'Delhi', 'Ron')
Insert into tblDepartment values(3, 'HR', 'New York', 'Christie')
Insert into tblDepartment values(4, 'Other Department', 'Sydney', 'Cindrella')


Insert into tblEmployee values(1, 'Tom', 'Male', 4000, 1)
Insert into tblEmployee values(2, 'Pam', 'Female', 3000, 3)
Insert into tblEmployee values(3, 'John', 'Male', 3500, 1)
Insert into tblEmployee values(4, 'Sam', 'Male', 4000, 2)
Insert into tblEmployee values(5, 'Todd', 'Male', 2800, 2)
Insert into tblEmployee values(6, 'Ben', 'Male', 7000, 1)
Insert into tblEmployee values(7, 'Sara', 'Female', 4800, 3)
Insert into tblEmployee values(8, 'Valarie', 'Female', 5500, 1)
Insert into tblEmployee values(9, 'James', 'Male', 6500, NULL)
Insert into tblEmployee values(10, 'Russel', 'Male', 8800, NULL)

[Csharp-video-tutorialsBlogspot]

Thank you very much for taking time to give feedback. In the description of this video, I have included the link for ASP .NET, C#, and SQL Server playlists. All the videos are arranged in logical sequence in these playlists, which could be useful to you. Please share the link with your friends who you think would also benefit from them. If you like these videos, please click on the THUMBS UP button below the video. For email alerts, when new videos are uploaded, you may subscribe to my channel.

[Csharp-video-tutorialsBlogspot]

Hi, all the information that is present in the slides is available on my blog.

[globalmacro]

The best 17 mins spent in my life. This is so clear and straight to the point!

[zlatkozeco]

Thanks for really good explanation. May Allmighty bless you

[ajitcs]

Finally the fear of hearing the Join query name lifted , it was so easy and your video explained it in such a simple language, thanks a lot

[michelazzo]

All this is valid also for MySQL, except for the full join, which isn't supported. Good stuff nonetheless! Thanks

[KARTHIKB]

Hi venkat can you explain Multiple inner joins to connect more than two tables(Ex: Four Tables)

[matterman]

Have went through many of your tutorials and the one on LINQ was phenomenal...many thanks for these!

[MinhTran-wnri]

Tip: You can "OUTER LEFT JOIN" the left_table with multiple right_table.

[Kyser]

You are such a awesome person, I can understand your explanations your voice is really clear you helped me out a lot for a test I have tomorrow