Inner Join, Left Join, Right Join and Full Outer Join in SQL Server | SQL Server Joins

[@questpondvideos]

20+ SQL Server Interview Questions : kzbin.info/www/bejne/iXbHcnluorh-iZY SQL Server Joins : kzbin.info/www/bejne/gYXZint7o9mppJo SQL Step by Step - kzbin.info/www/bejne/q3jPl4NvpJyeo7s 20 MSBI Interview Questions : kzbin.info/www/bejne/hKjCpHt7gNOCi6c 10+ Power BI Interview Questions : kzbin.info/www/bejne/eaDdlGyNg6eFqpY Software Architecture Interview Questions : kzbin.info/www/bejne/d6W3mJaYgbSkg68 Angular Step by Step Tutorial for Beginners : kzbin.info/www/bejne/Y2q5lIptgqd3qZo 25 Angular Interview Questions : kzbin.info/www/bejne/Y5vIoKx6f6mmia8 35 Important JavaScript Interview Questions : kzbin.info/www/bejne/kJOXlYOfbKh0hLc 30 Important C# Interview Questions : kzbin.info/www/bejne/eHzcn3h4hdacf68 25+ OOPS Interview Questions : kzbin.info/www/bejne/q2qcqHSld893rLM 25 Important ASP.NET Interview Questions : kzbin.info/www/bejne/ponQfpejf7p2Zsk 20 PHP Interview Questions : kzbin.info/www/bejne/Z5PTf4avo7qlopo 5 MSBI Interview Questions : kzbin.info/www/bejne/a3abYmiXjaaqj7M 20 MySQL Interview Questions : kzbin.info/www/bejne/b5nJm3Zjd9WMaJI

[@jerkifer924]

Just in case you missed it, the consensus is 'This is the most succinct and clear explanation of Joins.' Subscribed. You, Sir, are a legend. Thank you for your service.

[@MartyMacFry]

You are the FIRST person I have ever seen to explain what "LEFT" actually means in context of the tables. Everyone else doesn't talk about what that means but you did. Thank you for that.

[@santoshsahani6685]

,

[@hawnannahian9538]

Agree with you

[@jerkifer924]

HELLO McFLY!!!

[@MartyMacFry]

@@jerkifer924 this is heavy

[@nelikhan3314]

But table ks py bnaya or kese sql mei le gy

[@sophielourence]

all good. only the red circles are wrongly illustrating left and right join: the whole circle should be red, cause matching data is also included

[@master_zenrade]

Ahh yes. I also noticed that one.

[@anantgoswami7161]

Yaa. Exactly.

[@ganeshtalluridsyg9649]

Yes mam, need to fill red colour matched records from left table and right table ....

[@zeelthumar]

True...totally agreed

[@professorpoke]

The only reason I gave this video a dislike 👎

[@angieserrao2270]

You, Sir - are a great teacher. I've been working with SQL for over 6 months - yet by watching this video I realised how little I actually understood about joins! Thank you - will now check out the rest of your content. Thanks

[@tayyab2323]

Thank you for explaining the concepts. I think there is a small mistake in the Venn diagrams of Left join and Right join. Since both joins include data from the Inner join as well, the overlap in the Venn diagram should also be highlighted red.

[@EdwinVeenboer]

i thought this was hard to understand, but you sir, you made it all clear. thank you

[@abdoaboganima]

In the venn diagrams, the intersection should also be included in the left and right joins.

[@shikhar7385]

Short & Precise Completely understood in 8 mins

[@hienle-kc6qw]

we have this expert at work and he tried to train everybody on this subject for an hour but no one could understand! This video makes it seems like a walk in the park! :)

[@cdmurphy1981]

that was the best join tutorial I have found on KZbin. Really clear explanation!

[@lebohangmotsepe6335]

I second that.

[@spcexodus]

AWESOME explanation! Thank you so much for using simple explanations and making this a breeze to learn. I felt these were difficult and scary - now it's whatever - you've unraveled the mystery! Now to move on to more difficult joins :) Thanks again for helping me in progressing my launch of a new career! RECAP ON LESSON: INNER Join will display: ALL records that match between both tables. LEFT Join will display: ALL records from left table and MATCHING records from right table. RIGHT Join will display: ALL records from right table and MATCHING records from left table. FULL OUTER Join will display: ALL records from ALL tables.

[@LightningShiva1]

Thanks man

[@tharealminipunch]

Went through an entire course on databases at a well known university and learned more about joins from this video than the entire course, gotta love it

[@camilasampson478]

Did i just learn what my teachers were trying to teach me in 3 months in 8 minutes? wow...

[@pyotrpig]

it only seems so. if those 3 months of study were not there you wouldnt understand it now in 8 min

[@mr.badanalogy9502]

@@pyotrpig Nah fam just started learning MySQL yesterday. This is just a solid explanation with no fluff.

[@Wisdom-eg1gp]

thank you man. Almost no one seems to explain the concept of LEFT, RIGHT but you . everybody uses left right, full, without explicitley expalining to the student how to determine which table is at the left or right. You explained very well

[@carolinebraley6301]

Fantastic summary of JOINs. I need a refresher and this was clear, concise and quick. The Venn diagrams helped a lot too. Thanks!

[@randomness3235]

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.

[@ddx9197]

Your comments on those query types are correct, however your drawings with circles for left and right join are incorrect: (A) for left join, the entire left circle should be full of red color, including overlapped part; (B) for right join, the entire right circle should be full of red color, including overlapped area.

[@RamyHaramy]

I watched so many videos on joins but was always somewhat confused, you just made me understand it perfectly. Thank you so much!

[@FrantisekNovak55]

Left and Right join diagrams are wrong...

[@yunuskasimk]

vlastos That's what i was thinking too

[@jaemiah1515]

left and right are wrong!

[@seanpolley8529]

The diagrams are showing the right excluding and left excluding while the video is talking about full right and full left.

[@harvintoledo734]

With his explication it's enough. We don't need a correct Venn's diagram.

[@sachinpatil9564]

Yes. It should cover the common part as well.

[@ja3sk3adik55]

This is THE BEST explanation I have found, I can't believe that I have just found this video 7 years since the initial upload. I wish I came across this video a long time ago. I want to thank you so, so, so very much for posting this. Most especially the left and right join explanation. It is the clearest explanation I have ever gotten. Thank you sir.

[@JeanAlesiagain3]

Excellent explanation! Your accent is easy to understand too. Thank you!

[@Daoseth]

It has been a long time since I have used SQL and this got me back up to speed in minutes. THANK YOU FROM LOUISIANA!

[@StevenBrener]

Very clear concise comprehensible explanation. Thanks!

[@aparnapandravada5073]

Superb! Saw somany tutorials of SQL joins, but none of them explained this much clear... it's crystal clear...👍

[@vishnum9692]

Good explanation .The diagrams are not proper i seems If the left join dispalays all data from left table and matching records from the right table , the red shade should fill the intersection of the 2 circles wiz 'Country' and 'State' Similarly for right join also.

[@samantharutendodoba6302]

i think so too

[@shivamthesomeone3078]

Ya I think it tooo...

[@arnoldsujankatru9667]

UPloaded 10 years Ago still giving a clear explination Hats Off

[@yotuber09]

Great work with explaining the basics but one mistake the diagrams are incorrect for the left join and right join, the red shade should fill the intersection of the 2 circles wiz 'Country' and 'State' for both the joins

[@KentOJohnson]

Finally a quick, understandable explanation! It seems like people think with inner, right, and left joins frequently, they just don't know they are thinking like a DBA. Thank you!

[@bharathkumar9971]

Good explanation, But Please correct the Venn-Diagrams for Left and Right joins. so that the learners can not miss understand.

[@ALLCPL]

good job

[@DineshKumar-lq2ck]

After hunting whole day this video answers the question. I am short of words to express my gratitude. Also i take help of your C# tutorials. Thank you Sir.

[@questpondvideos]

👊👊👊👊👊👊Smash Subscribe button if you like it.👊👊👊👊👊👊

[@smaklilu90]

Venn diagram is wrong it should be like this ibb.co/f2gMb9

[@ruinfirefly2088]

7 year old video still more informative than others

[@SuperMega_E]

are Natural Join and Full Outer Join are same?

[@nitishkumarpatel8490]

When i see the diagram of left and right join i literally confused its wrong matching record + left table all record should be displayed

[@roydenpereira5726]

Good explanation with example but the venn diagrams are incorrect. For left join if "all records from left table are returned" then shouldn't it cover the common/intersecting part in RED as well? Same for right join

[@JohnWaclawski]

I still struggle with JOINS but you made quite a bit of sense when you explained to put the tables side-by-side to differentiate between the LEFT and RIGHT table. It always confused me as to which one was the LEFT and which one was the RIGHT. Thank you!!!

[@TheBongRapper]

It is easy here, but when we use multiple tables and joins , i still get confused which one to consider as the left join then 😐

[@sameeranandtorvi]

Amazing explaination.. except the left and the right join intersection needed shading.. But still.. short and simple.. Thanks

[@vinoderramsetty1093]

Awesome in just 8mins. Thanks!!

[@medobigposs]

Good job! However, the drawings for left and right joins are incorrect

[@francis191]

This is one of the best explanations of inner joins, left joins and rights joins I have come across. Great session

[@questpondvideos]

yes you are right , our mistake ;-)

[@intuitiveclass6401]

I went through an entire month misunderstanding the use of these JOINS, thank you for some goddamn clarification!!

[@DanielAngali]

Thanks for explanation.Please correct the venn diagrams.

[@michaelsomers349]

Great execution, even a baby could understand that. Awesome

[@I-believe-in-humanity]

nice , but please correct Venn-Diagram

[@sory6783]

I opened up five other tabs. Your explanation was soo good I closed them cos you gave me what I needed.

[@arunoday.r693]

Thank you so much...could understand easily

[@kashifumer8755]

First person with the common sense to explain what the 'left' in left-join means! Thanks. Please start a course on Udemy so I can pay you for your sensibilities.

[@raviprakash8092]

Venn-diagrams r wrong..when u say all the data from..left/right...tables..y the full circle were not highlighted ?...rest all good effort..!

[@pedishettys]

It was the best join tutorial I have found on KZbin. Really clear explanation!

[@SeanAxion12]

I've always created a blank table and then used 'for each row in table {' with my stipulation to populate the desired table. This is much more efficient though, I can see why my method will quickly become very slow. Thanks! (Learning as I go ha ha)

[@Merajmohdkhan]

good explanation just need to do little conceptually correction in the diagram..but good work

[@mmezzab]

+meraj khan yeah, the left and the right join just need to have the intersection painted red

[@xarzu]

+meraj khan I was thinking the same thing. Glad I was not the only person to recognize that with the left and right join.

[@outrangers]

Wow ! This is by far the best tutelage on Joins. I had been scouting for a while to find a naive stream to understand but this is too good. Great going!

[@love2al]

Did anybody notice that vein diagrams for left and right Joins are wrong??

[@prateekkish]

Yup. In case of right and left, the intersection part should have been colored as well.

[@ragiththomas9510]

I understood all the joins. It's very easy to understand, simple examples are very easy to understand. You rocking man. thanks a lot

[@sahilsheikh610]

Your venn diagram for left and right outer join is incorrect.

[@aeliyazaheer6792]

Excellent explanation.. Now my Concepts about joins are completely clear.. GOD Bless U.

[@InternPalooza]

Please remove the misleading diagrams... It confuses people ....

[@amilawijesekara4990]

This is an excellent session. I had difficulties with joins and your explanation is crystal clear. Well done and thanks a lot.

[@michor10]

Yes, your diagrams suck. Why would you want to confuse people? That's just mean, man.

[@aparnam6247]

First time i got so clear explanation. Thank you sir

[@aurora5399]

Wow! Best video lecture on joins ( especially left and right joins)...

[@ramyab6961]

Everything is very clear in this video. Revised section is added advantage of this.

[@hoplahey]

Thank you. I had this in school 20 years ago and did not understand since it was not well explained. This was incredebly simple.

[@jaycornucopia]

Clearest explanation I have ever found! Thank you!

[@miguelsousasoares]

Brilliant explanation!!! Very clear. The best explanation about JOIN SQL function. Thank you

[@SiriB-l4u]

1.7M views shows how simply, effectively, neatly u presented, thanks a lot sir🙏🙏🙏

[@greatvedas]

As clear as water ! thats the best explanation I ever heard. Thanks for publishing this video.

[@sn4yker]

Great demonstration, i was a little bit confused with the different types of joins, (even after watching different videos)... but now i understand, your video is simple and very intuitive. Of course, your english is better than other indian teachers. Thanks

[@Philbrazil]

yesssss I finally comprehend joins!!!! thank you so much!

[@nikhildasari9702]

After Watching This Video The Joins Concepts Are Very Very Clear......Good Work Sir jiiiii

[@NitinKumar-ey3zx]

Nice and crisp explanation. Less wastage of time. To the point!

[@ravikumar-ep9je]

first time I understood joins clearly.. superb.. thanks a lot..

[@yogeshnaik936]

best join tutorial ever found on KZbin.

[@danielgitahi2847]

Thanks for the wrong right and left diagrams. But your explanation was so clear that i completely understood the concept and corrected your diagrams. Good work bro!

[@mohammadghufran3494]

awesome sir, a lot of respect for you. after watching several videos, I found your video, which made to learn Joins queries, you explained in brilliant and made it easy for me to understand. Your video is most creative and easy to make out these joinders. Thank a ton. keep it up,

[@informationandentertainmen536]

Thank you for making me understand. My coach didn’t explain it properly . You have explained it in such a simple language. Much appreciated

Very good explanaition. I understood much better the joins after watching this! Thanks a lot!

[@Moank23]

Thank you very much. This video finally cleared the SQL JOIN concept for me. Very simple explanation. God bless you!

[@haciendadad]

Simple video but clearly explains these joins. Yes, the Venn diagram is not correct for the Left and Right Joins, the inner overlap should be colored, but other than that, it is a good easy explanation.

[@matiuspakpahan7612]

left table = from right countryy + joint on we say right and left is because, if they are written in single line the FROM will be located left of JOIN ON INNER JOIN = include all rows that has value/no null LEFT JOIN =include all row and row that has null value from **FROM table (LEFT TABLE)** RIGHT JOIN =include all row and row that has null value from **JOIN table (RIGHT TABLE)** FULL JOIN =include all row and row that has null value from **BOTH TABLE**

[@rozansanjitha6287]

Thanks a lotttt… it really helped me a lot. Now I’m crystal clear with joins in SQL.❤❤

[@sabrinsabrin566]

Thanks for your Video posted ,it is so help full to understand joins .The way you explained it ,it make it so easy to understand than other tutorial .

[@abhishekmukherjee2091]

Best explanation on joins i have seen so far.

[@abdrk1]

Simple explanation, easy to understand. Thank you very much. But I believe there is some rectification needed in the diagram of left and right join

[@maheshreddypesala266]

Short and clear🔥✌️...

[@HarishGGU]

You are awesome teacher. your explanation your clean voice your presentation your example according problem solutions and topics your teaching step by step you take very less time and explain big things in very easily i am biggest fain of you.

[@NaveenKumar-xs3no]

Superb and clear explanation sir you posted a video on 2012 but iam watched in 2020 it is very helpfull for the join condition beginers..........

[@matousoleksak8790]

Simple explanation. Love from Czech Republic.

[@shlomi441]

Great video, I also appreciate the fact that you (unlike many many others on YT) added subtitles

[@SoftwareTestSolutions]

This is one of the best videos I have seen so far!

[@sanwal1981]

I really like the way in which joins are explained I understood very easily about it and will never forget thanks!!!

[@mr.win_minigames3615]

Thanks.... This will be helpful for interview part happening in next week....

[@paulreuter3238]

for right and left join in the red circle diagram I believe the overlapping part of the circles should be red as well, because not only all information from one table is displayed but also the matching from the other

[@iahmedsh_]

Very great effort sir thanks alot, circles of left and right joins are wrongly illustrated because the whole circle will be red because left table intersects right table and right table intersects left table.

[@hawnannahian9538]

Mannn! Awesome explanation. I found this explanation is the best explanation ever about joins.

[@mr.badanalogy9502]

An absolute straightforward explanation, solid job Mate.

[@papusahoo]

I was earching a proper answer from a long time, this video made me clear by using venn diagram. Thanks a lot .... :-)

[@MeuTube]

This man is the G.O.A.T. Much love and support

[@liaGend]

This was all that I was searching for. THANK YOU!

[@manpatel4145]

Thanks for good explanation 👍.

[@k9870]

Fabulous concept ,learned joins in 8 minutes...👌👌👌only diagram is little incorrect..U deserve more viewers ND subscribers...

[@AndreasvanHaren]

Very helpful, thanks! Now if I would like to see the joint information only, should I make a new table for this?

[@zinemeki3017]

Eloquent and lucid explanation; Please change the left and right Venn-diagrams to illustrate the explanation. Additionally,on the left join table Srilanka has a countryId 3 not null. Otherwise

[@ruchapupala8471]

Most clear and precise , simple explanation 👍👍