HomeОбразованиеRelated VideosMore From: Questpond

SQL Server join :- Inner join,Left join,Right join and full outer join

11569 ratings | 907011 views
For more such videos visit http://www.questpond.com For more such videos subscribe https://www.youtube.com/questpondvideos?sub_confirmation=1 Also watch Learn Sql Queries in 1 hour :- https://www.youtube.com/watch?v=uGlfP9o7kmY See our other Step by Step video series below :- Learn Data Science in 1 hour :- https://tinyurl.com/y5o7qbau Learn angular tutorial step by step https://tinyurl.com/ycd9j895 Learn C# Step by Step https://goo.gl/FNlqn3 Learn Design Pattern Step by Step https://goo.gl/eJdn0m Learn SQL Server Step by Step http://tinyurl.com/ja4zmwu Learn Data structures & algorithm https://tinyurl.com/ybx29c5s Learn MVC Core step by step :- http://tinyurl.com/y9jt3wkv Learn MSBI Step by Step in 32 hours:- https://goo.gl/TTpFZN Learn Xamarin Mobile Programming Step by Step :- https://goo.gl/WDVFuy Learn SharePoint Step by Step in 8 hours:- https://goo.gl/XQKHeP Learn Tableau step by step :- https://tinyurl.com/kh6ojyo Preparing for C# / .NET interviews start here http://www.youtube.com/watch?v=gaDn-sVLj8Q In this video we will try to understand four important concepts Inner joins,Left join,Right join and full outer joins. We are also distributing a 100 page Ebook ".Sql Server Interview Question and Answers". If you want this ebook please share this video in your facebook/twitter/linkedin account and email us on [email protected] with the shared link and we will email you the PDF.
Html code for embedding videos on your blog
Text Comments (662)
Questpond (9 months ago)
👊👊👊👊👊👊Smash Subscribe button if you like it.👊👊👊👊👊👊
SuperMega Erian (2 months ago)
are Natural Join and Full Outer Join are same?
Dibbendu Koley (2 months ago)
7 year old video still more informative than others
samuel gebru (7 months ago)
Venn diagram is wrong it should be like this https://ibb.co/f2gMb9
Samuel P (3 days ago)
Good explanation
Pravin Kumar (5 days ago)
Clear and concise explanation 👌
Chieh-Yu Lin (8 days ago)
Search for this tutorial article for 1 hour and still don't understand. But after saw your 8min video, it let me fully understand what is left join and right join. Thank you so much!
Hyun Cho (12 days ago)
thank you!
Varun Parashar (20 days ago)
Thanks a Ton
Prasanthi Bodda (22 days ago)
Thank you sir
Hello World (1 month ago)
I hope that I have a teacher like you
Imran Munawer (1 month ago)
Very good
Muhammad Asim (1 month ago)
Fantastic... Sir You have great teaching skills I must say... May Allah Bless you....
Arjun Prayoga Aji (1 month ago)
thank you for the interpretation, this help me as beginner. but i think i have single correction for your better visualization. when you visualize left join, i think it would visualize trimmed area. in other word it cover the left area and inner join area. but after all your visualization idea is absolutely amazing.
saravanan chellan (1 month ago)
This venn diag is wrong
Anar Qasimov (2 months ago)
https://www.w3schools.com/sql/sql_join.asp
Scorpio (2 months ago)
Wow! Best video lecture on joins ( especially left and right joins)...
Tobbe E (2 months ago)
Thanks for explaining this dude. I am pretty new to SQL.
Wasim Khan (2 months ago)
Stay Blessed,,, thank you for explaining joins so beautifully
SKY World (2 months ago)
Awesome
SHILPA SINGH AMETHI (2 months ago)
CAN YOU PLZ EXPALIN LEFT OUTER JOIN AND RIGHT OUTER JOIN WITH ONE MORE EXAPLE
Hamza Ayad (2 months ago)
What the fuck is one-ly its fucking only
fupopanda (2 months ago)
Like other pointed out, the venn diagram for the LEFT JOIN and RIGHT JOIN are wrong. The intersection portion should be shaded in both. Besides that, amazing video.
Leonid Kork (2 months ago)
video super!!! thank you.
Suryanarayan Subudhi (2 months ago)
what is difference between left join and left outer join???
SuperMega Erian (2 months ago)
are Natural Join and Full Outer Join are same?
Samiul Siddique Shakil (2 months ago)
Very Nice and Thank You...
Random Ness (3 months ago)
This video has cleared many hours of trying to understand these joins, and in only 8 minutes and 10 seconds or less. Now it all makes simple sense, lol. Thanks for posting this.
Gourav Rajpurohit (3 months ago)
Nice explanation
Jake Azura (3 months ago)
Thank you
anand reddy (3 months ago)
HI SIR I WOULD LIKE TO KNOW HOW TO ADD TWO DAYS OF DATA SIMULTANEOUSLY IN A SINGLE DATABASE.I HAD DATA IN THE FORM OF EXCEL FOR DATES OF 11/02/2017 AND 12/2/2017 PLEASE HELP ME TO OVERCOME THIS PROBLEM
Purple-Death (3 months ago)
Thank you for that excellent explanation of such a difficult subject. I was having trouble with joins, but now I get it.
Sheela Akshay (3 months ago)
What will be the query to fetch the details of all the employees who knows two additional languages (speak and read) other than their mother tongue and their salary must be greater than 50000?
Rahul Prakash (3 months ago)
full outer join doesn't support in mysql workbench.
left , right drowing is wrong!!!!!!
Chami online (3 months ago)
Perfect lession
Shlomi Bonner (3 months ago)
Great video, I also appreciate the fact that you (unlike many many others on YT) added subtitles
PRASAD PAWAR PATIL (3 months ago)
Good Explanation
Awesome
gana shikho (4 months ago)
Really today I understand how join work
Jawad Amir (4 months ago)
the best explination
Rucha Pupala (4 months ago)
Most clear and precise , simple explanation 👍👍
Anuj Singh (4 months ago)
Really good explanation
Mark Mark (5 months ago)
Great Video Thanks!!
Saiprasad Kyatam (5 months ago)
This video made me full clarity in a simplified way Thank you Sir.
alik dv (5 months ago)
You should correct Diagram for Left and Right join its wrong don't confuse people !!!!!!!!!!!!!!!!!!!!!!!
chu mohalla (5 months ago)
Thanks bro
Viplov Vats (5 months ago)
Superb explanation!! But diagrams are not correct!!
priyanka rana (5 months ago)
Nice Video
Abhishek Mukherjee (5 months ago)
Best explanation on joins i have seen so far.
Mohammad Shameer (6 months ago)
Awesome video. Great understanding in just 8 minutes. Good going keep it up!!!!
Solution Domain (6 months ago)
Liked and subbed. Felt happy. Thank you.
Solution Domain (6 months ago)
Very clear presentation. Thank you very much.
V.Ajit Raju (6 months ago)
Sir your left and right diagrams looks wrong ....but concept is correct
piano0011 Lee (6 months ago)
This is a good tutorial but I have a two tables... one is a general information table showing which users are premium or not and the other table is the premium table but I don't have any matching columns in both tables... I like to do a query something like this... select * from users where premium = 1 and select * from memberships where subscriptionplan = level 1.... The user must be a premium and level 1 user... should I use left join?
Fatharani Wafda (6 months ago)
keep it up !!
v Mohanapriya (6 months ago)
Clear explanation
Manjunath Beli (7 months ago)
Simple and crystal clear example. Thank you for doing the video.
michael dalip (7 months ago)
nice video, thank you!
Romin Xavier (7 months ago)
Thanks man for this wonderful video
Kumar Chowdary (7 months ago)
Osm
Rohit Thadkapalli (7 months ago)
I was always confused with joins, but this video gave me precise understanding! Thank you!!!
Ahmed Reza (7 months ago)
why my full outer join is not executng?? i m using mysql
Venkateswarlu Moluguri (7 months ago)
Left and Right Join Diagrams are wrong
Mohan Kondel (7 months ago)
Thank you very much. This video finally cleared the SQL JOIN concept for me. Very simple explanation. God bless you!
Bvino 34 (7 months ago)
Super explanation. Tq sir
Aboodnet (7 months ago)
What about using just join ?
Ravi (7 months ago)
excellent explanation.
kalpa perera (7 months ago)
Great work, quick and nice explanation Thanks for put my country : Sri Lanka We love India too
amolchaitanya (7 months ago)
Super simple explanation
shantanu rauthan (7 months ago)
whats with that blackout at 0:40 .for a moment i thought my laptop's died.Anyway nice video
SHIKHAR GUPTA (7 months ago)
plain, simple and precise. Good job.
Shane Detsch (8 months ago)
I am using mysql and had to UNION the Left and Right Joins to reproduce the results for the above FULL OUTER JOIN.
kshitij gupta (8 months ago)
nice
Edgar Sanchez (8 months ago)
Wow, I was really struggling to understand how or where LEFT, RIGHT, OUTER came from. You cleared up so many questions I had in this one video. Thanks a lot!! And forget everyone who says your diagram is wrong, everyone who codes knows that coding develops and teaches you how to think. They should be smart enough to rethink the way they see the diagram
Nikita Bagga (8 months ago)
Wow....amazing
Mahendr Rule (8 months ago)
Thank sir
Gokilavani M (8 months ago)
can u plz...... all update videos for DCL and TCL comments ..........
Gokilavani M (8 months ago)
i like ur way of teaching.......
rutuja inzalkar (8 months ago)
Very Good explanation sir...👍
bhargavi smiley (8 months ago)
Nice sit
Bharathkumar Achari (8 months ago)
Easy explanation...... Nice
Akash putti AMP ROCKER (8 months ago)
awesome explanation bro
Rohan Pawar (8 months ago)
what if both tables have multiple null values than how it will be match also if both table have multiple same value like 1,1 and in other as well 1,1 then what will be the output will it be 4 records (2*2 possible combination)
Dilshan Isuranga (8 months ago)
Nicely explained. Thanks from Sri lanka.
Muhamad Sadikin (8 months ago)
Clear example
Vinay Kumar (8 months ago)
The concept is very well explained, thank you very much
Ganesh Chittalwar (8 months ago)
When we are use one table but in the table 1,2,3,4,5, is number but there 2 and 4 missing number the how to find this number in the table ?....tell me sir
Pratibha Patil (8 months ago)
Thankyou...you are so clear!
Nipul Sindwani (8 months ago)
helped a lot
Ankit Makwana (9 months ago)
Nyc1
lapidations (9 months ago)
Thank you so much for the explanation. Even if the Venn Diagrams for Left and Right are wrong, your explanation is beautiful, I finally understood it. I only know the diagrams are wrong because you sucessfully taught me how outer joins work! Thanks again.
pallav sanwal (9 months ago)
I really like the way in which joins are explained I understood very easily about it and will never forget thanks!!!
Pradip Dhakal (9 months ago)
Very well explained Sir!
Arpita kulkarni (9 months ago)
Thank u Soo much...good explanation.
Joe Behymer (9 months ago)
Excellent demonstration and explanation of this topic!
Aslam Sayyed (9 months ago)
Good explanation
Imrul Hasan (9 months ago)
best way to teach.... thank you Sir....
Clear and simple..... Superbb
benarjee 1997 (9 months ago)
left and right diagrams are wrong
MUHAMMAD RISHAD (9 months ago)
nice explanation....!!
Karan Bir Sandhu (9 months ago)
thnx
thanks. nice explanation. :)

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.