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

Buy SQL Server course from here www.questpond....
For more such videos visit www.questpond.com
For more such videos subscribe www.youtube.co...
See our other Step by Step video series below :-
For more such videos subscribe / questpondvideos
See our other Step by Step video series below :-
JavaScript Interview Questions: • JavaScript Interview Q...
Learn SQL Server Step by Step tinyurl.com/ja4...
Learn MSBI Step by Step in 32 hours:- goo.gl/TTpFZN
Python Tutorial for Beginners:- • Python Tutorial for Be...
Learn Data Science in 1 hour :- tinyurl.com/y5...
Learn Power BI Step by Step:- tinyurl.com/y6...
PHP Interview Questions : • PHP Interview Question...
C# tutorial for beginners(4 hrs):- • C# Tutorial for Beginn...
Learn Azure Step by Step:- • Azure Tutorial for Beg...
Azure AZ-900 fundamentals certification :- • AZ 900 Certification |...
Angular Interview Questions and Answers :- • Angular Interview Ques...
Learn Angular tutorial step by step tinyurl.com/yc...
Learn MVC 5 step by step in 16 hours:- • Learn ASP.NET MVC 5 ( ...
Learn Design Pattern Step by Step goo.gl/eJdn0m
Learn Tableau step by step :- tinyurl.com/kh...
Preparing for C# / .NET interviews start here • C# Interview Questions...
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 [e-mail] with the shared link and we will email you the PDF.
-----------------------------------------------------------------------------------------------
For more details :-
🌐 Website : www.questpond.com
📱 Mob. No. : [phone] / [phone] / [phone]
📧Email : [e-mail] / [e-mail] / [e-mail]
Share, Support, Subscribe and Connect us on!!!
KZbin: / questpondvideos
Twitter: / questpond
Instagram : / questpond
Facebook : / questpond
#InnerJoin #SQlServerTutorial #LeftJoin #SQL #RightJoin #SQLServercourse #FullOuterJoin #JoinsinSQLServer #SQLServerInterviewQuestions #SQLServerInterviewQuestions&Answers

[@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 👎

[@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.

[@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

[@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! :)

[@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

[@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

[@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.

[@RamyHaramy]

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

[@carolinebraley6301]

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

[@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

[@JeanAlesiagain3]

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

[@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.

[@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.

[@StevenBrener]

Very clear concise comprehensible explanation. Thanks!

[@josephbeaudion344]

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!

[@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...

[@aparnapandravada5073]

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

[@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.

[@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 😐

[@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

[@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.

[@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

[@arnoldsujankatru9667]

UPloaded 10 years Ago still giving a clear explination Hats Off

[@sameeranandtorvi]

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

[@francis191]

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

[@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

[@supermegae7573]

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

[@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!

[@questpondvideos]

yes you are right , our mistake ;-)

[@vinoderramsetty1093]

Awesome in just 8mins. Thanks!!

[@medobigposs]

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

[@aurora5399]

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

[@arunoday.r693]

Thank you so much...could understand easily

[@aeliyazaheer6792]

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

[@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.

[@michaelsomers349]

Great execution, even a baby could understand that. Awesome

[@DanielAngali]

Thanks for explanation.Please correct the venn diagrams.

[@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.

[@sory6783]

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

[@I-believe-in-humanity]

nice , but please correct Venn-Diagram

[@pedishettys]

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

[@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

[@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..!

[@NitinKumar-ey3zx]

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

[@sahilsheikh610]

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

[@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.

[@InternPalooza]

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

[@aparnam6247]

First time i got so clear explanation. Thank you sir

[@michor10]

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

[@amilawijesekara4990]

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

[@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

[@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

[@intuitiveclass6401]

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

[@SiriB-l4u]

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

[@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!

[@Moank23]

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

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

[@miguelsousasoares]

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

[@rasmank]

Thanks for the explanation, I have always been struggling to understand where the left table is. Now its very clear. Kudos!!

[@questpondvideos]

Thanks

[@rohitrox8]

I was always confused with joins, but this video gave me precise understanding! Thank you!!!

[@mr.badanalogy9502]

An absolute straightforward explanation, solid job Mate.

[@ravikumar-ep9je]

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

[@nikhildasari9702]

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

[@Philbrazil]

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

[@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..........

[@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!

[@rozansanjitha6287]

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

[@ramyab6961]

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

[@sanwal1981]

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

[@maheshreddypesala266]

Short and clear🔥✌️...

[@yogeshnaik936]

best join tutorial ever found on KZbin.

[@jaycornucopia]

Clearest explanation I have ever found! Thank you!

[@Anand_Sriram]

Explained in a very simple understandable way. Thank you for teaching.

[@manpatel4145]

Thanks for good explanation 👍.

[@hawnannahian9538]

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

[@matousoleksak8790]

Simple explanation. Love from Czech Republic.

[@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.

[@shlomi441]

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

[@collettedrive]

Very good explanation I bet I will ace joints in my exam tomorrow even my lecturer didn't explain this clear.Thank you very much 👌

[@deanmoncaster]

JOINTS?!?!?!I want to go to your school!!

[@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,

[@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.

[@AhmedKhaled-he9mf]

Thanks very much for nice explain, I love when in the first you display the both tables as small not large data, thanks very much

[@k9870]

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

[@manjubeli]

Simple and crystal clear example. Thank you for doing the video.

[@GhulamSuleman-j2v]

Sir, well explained, fully covered the JOIN topic with practically applying

[@ramakrsihna868]

super got cleared of what exactly LEFT means . Thankyou so much

[@venkysc]

Cleared by doubts with this video. Thanks for sharing the knowledge.

[@kumarcok]

No Wonder there is, this much views for this video !! Wonderfully Explained the concepts..

[@muhammadasim8873]

Fantastic... Sir You have great teaching skills I must say... May Allah Bless you....

[@anjalipatel1718]

Thank you very much for providing us such a clear , understandable video. It will clear all my doubt within 9 minutes

[@rajkiranboggala9722]

That’s simple and easy way of explaining the joins. Thanks

[@ruchapupala8471]

Most clear and precise , simple explanation 👍👍