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

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

11978 ratings | 933435 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 (673)
Questpond (11 months ago)
👊👊👊👊👊👊Smash Subscribe button if you like it.👊👊👊👊👊👊
SuperMega Erian (4 months ago)
are Natural Join and Full Outer Join are same?
Dibbendu Koley (5 months ago)
7 year old video still more informative than others
samuel gebru (9 months ago)
Venn diagram is wrong it should be like this https://ibb.co/f2gMb9
Issues of Life (1 day ago)
great informative video, Regards, https://www.udemy.com/basic-concepts-of-databases-and-writing-query-in-sql-server/?couponCode=LEARNSQLSERVER
Aakash Dubey (1 day ago)
Fantastic explanation. thanks for make me understand in very simple way. one of the best videos on joins
KX163F (3 days ago)
Thank you
Gurpreet Singh (9 days ago)
I can't thank you enough.
Malak Gerges (11 days ago)
Good tutorial, but you didn't mention the "cross join" and its shortcut
Sameen Akhtar (11 days ago)
Legendary 👍
kota krishna latha (21 days ago)
Quickly understood..in simple way
ronald abellano (22 days ago)
holy beard! that’s quick and informative.
vyankatesh budharam (22 days ago)
Short video and best 👍💯
dabluerover (28 days ago)
What about a self join
MSBI Tutorial (29 days ago)
Good explanation!! If anyone is interested for SQL and MSBI classes, contact [email protected]@t just @ Rs 200 per hour
xLr8 (1 month ago)
Thank you a lot, you helped me really much!! Thank you <3
Poke A Brain (1 month ago)
I wasn't going to comment but I'm breaking the evil comment count of 666 :D ... yes, the graphs are misleading.. but are possible.. with 2 tables A = B (left join where B is null) or (Right join where A is null) : D Good explanation though! thanks for posting!
Monwabisi Xinwa (1 month ago)
GREAT EXPLAINATION BRAVO
Furkan Karakus (1 month ago)
do u kno da wae
debanjan chakraborty (1 month ago)
While joining there is redudancy how to remove it
Bala krishna (1 month ago)
Good one. Thanks for the video
Mohamed Abaza (2 months ago)
Good job! However, the drawings for left and right joins are incorrect
Samuel P (2 months ago)
Good explanation
Pravin Kumar (2 months ago)
Clear and concise explanation 👌
Chieh-Yu Lin (2 months 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!
HJ Cho (2 months ago)
thank you!
Varun Parashar (2 months ago)
Thanks a Ton
Burket Ali (2 months ago)
brilliant explanation
Prasanthi Bodda (2 months ago)
Thank you sir
Hello World (3 months ago)
I hope that I have a teacher like you
Imran Munawer (3 months ago)
Very good
Muhammad Asim (3 months ago)
Fantastic... Sir You have great teaching skills I must say... May Allah Bless you....
saravanan chellan (3 months ago)
This venn diag is wrong
Anar Qasimov (4 months ago)
https://www.w3schools.com/sql/sql_join.asp
Scorpio (4 months ago)
Wow! Best video lecture on joins ( especially left and right joins)...
Tobbe E (4 months ago)
Thanks for explaining this dude. I am pretty new to SQL.
Wasim Khan (4 months ago)
Stay Blessed,,, thank you for explaining joins so beautifully
SKY World (4 months ago)
Awesome
SHILPA SINGH AMETHI (4 months ago)
CAN YOU PLZ EXPALIN LEFT OUTER JOIN AND RIGHT OUTER JOIN WITH ONE MORE EXAPLE
Hamza Ayad (4 months ago)
What the fuck is one-ly its fucking only
fupopanda (4 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 (4 months ago)
video super!!! thank you.
Suryanarayan Subudhi (4 months ago)
what is difference between left join and left outer join???
SuperMega Erian (4 months ago)
are Natural Join and Full Outer Join are same?
Samiul Siddique Shakil (5 months ago)
Very Nice and Thank You...
Random Ness (5 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 (5 months ago)
Nice explanation
Jake Azura (5 months ago)
Thank you
anand reddy (5 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 (5 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 (5 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 (5 months ago)
full outer join doesn't support in mysql workbench.
left , right drowing is wrong!!!!!!
Chami online (5 months ago)
Perfect lession
Shlomi Bonner (5 months ago)
Great video, I also appreciate the fact that you (unlike many many others on YT) added subtitles
PRASAD PAWAR PATIL (5 months ago)
Good Explanation
Awesome
gana shikho (6 months ago)
Really today I understand how join work
Jawad Amir (6 months ago)
the best explination
Rucha Pupala (6 months ago)
Most clear and precise , simple explanation 👍👍
Anuj Singh (6 months ago)
Really good explanation
Mark Mark (7 months ago)
Great Video Thanks!!
Saiprasad Kyatam (7 months ago)
This video made me full clarity in a simplified way Thank you Sir.
alik dv (7 months ago)
You should correct Diagram for Left and Right join its wrong don't confuse people !!!!!!!!!!!!!!!!!!!!!!!
chu mohalla (7 months ago)
Thanks bro
Viplov Vats (7 months ago)
Superb explanation!! But diagrams are not correct!!
priyanka rana (8 months ago)
Nice Video
Abhishek Mukherjee (8 months ago)
Best explanation on joins i have seen so far.
Mohammad Shameer (8 months ago)
Awesome video. Great understanding in just 8 minutes. Good going keep it up!!!!
Solution Domain (8 months ago)
Liked and subbed. Felt happy. Thank you.
Solution Domain (8 months ago)
Very clear presentation. Thank you very much.
V.Ajit Raju (8 months ago)
Sir your left and right diagrams looks wrong ....but concept is correct
piano0011 Lee (8 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 (8 months ago)
keep it up !!
v Mohanapriya (8 months ago)
Clear explanation
Manjunath Beli (9 months ago)
Simple and crystal clear example. Thank you for doing the video.
michael dalip (9 months ago)
nice video, thank you!
Romin Xavier (9 months ago)
Thanks man for this wonderful video
Kumar Chowdary (9 months ago)
Osm
Rohit Thadkapalli (9 months ago)
I was always confused with joins, but this video gave me precise understanding! Thank you!!!
Ahmed Reza (9 months ago)
why my full outer join is not executng?? i m using mysql
Venkateswarlu Moluguri (9 months ago)
Left and Right Join Diagrams are wrong
Mohan Kondel (9 months ago)
Thank you very much. This video finally cleared the SQL JOIN concept for me. Very simple explanation. God bless you!
normal man (9 months ago)
Super explanation. Tq sir
Aboodnet (9 months ago)
What about using just join ?
Ravi (9 months ago)
excellent explanation.
kalpa perera (9 months ago)
Great work, quick and nice explanation Thanks for put my country : Sri Lanka We love India too
amolchaitanya (9 months ago)
Super simple explanation
shantanu rauthan (9 months ago)
whats with that blackout at 0:40 .for a moment i thought my laptop's died.Anyway nice video
SHIKHAR GUPTA (9 months ago)
plain, simple and precise. Good job.
Shane Detsch (10 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 (10 months ago)
nice
Edgar Sanchez (10 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 (10 months ago)
Wow....amazing
Mahendr Rule (10 months ago)
Thank sir
Gokilavani M (10 months ago)
can u plz...... all update videos for DCL and TCL comments ..........
Gokilavani M (10 months ago)
i like ur way of teaching.......
rutuja inzalkar (10 months ago)
Very Good explanation sir...👍
bhargavi smiley (10 months ago)
Nice sit
Bharathkumar Achari (10 months ago)
Easy explanation...... Nice
Akash putti AMP ROCKER (10 months ago)
awesome explanation bro
Rohan Pawar (10 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 (10 months ago)
Nicely explained. Thanks from Sri lanka.

Would you like to comment?

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