SQL Joins: Difference Between Inner/Left/Right/Outer Joins

Поділитися
Вставка

КОМЕНТАРІ • 312

  • @LaughinLoneStar
    @LaughinLoneStar 9 місяців тому +29

    Join/Inner Join = Keep only that which matches
    Left join = Keep every thing from left table, only matches from right table
    Right join = Keep everything from right table, only matches from left table
    Outer join = Keep everything

  • @Hoppensagen
    @Hoppensagen 2 роки тому +27

    Seriously, why do teachers not explain it simply like this, I was so confused, they just like explained in words what join is, and then write sql and show it and then I just have no idea what happened. Great visual.

  • @j.deluca8824
    @j.deluca8824 3 роки тому +371

    You made me understand this in 10 minutes, whereas I had no idea what was going on in my university lectures. Thanks lol

    • @sebastianvalenzuela3762
      @sebastianvalenzuela3762 3 роки тому +1

      same!

    • @sagardubey3800
      @sagardubey3800 2 роки тому +1

      same this side even........Universities have pro max teachers and he is just a teacher that's the reason we are not understanding anything from there

    • @Stavros33GR1
      @Stavros33GR1 2 роки тому +1

      same

    • @azimrahman3584
      @azimrahman3584 2 роки тому +1

      Yes this one cleared the doubt in only 10 min

    • @naimaaqeel8092
      @naimaaqeel8092 7 місяців тому

      Same here

  • @blindhydra
    @blindhydra 2 роки тому +55

    This is probably one of the best data analysis videos i've seen on youtube, thanks man I really appreciate it

  • @sparrowXXIII
    @sparrowXXIII Рік тому +1

    🙏!!!
    I desperately needed a visual explanation like this.
    Going to dive in your other videos and see what other magic visualizations you have up your sleeve!

  • @LoXena
    @LoXena 3 роки тому +95

    Thank you this is the best explanation I've found so far!

  • @thanhsangto8603
    @thanhsangto8603 3 роки тому +30

    That was such an easy guide to understand. I hope your channel will early expand more. thank you so much.

  • @keylanshannon9492
    @keylanshannon9492 2 роки тому +3

    This is really great content! Your visual break down solved about a week of my frustration!!

  • @meme1033
    @meme1033 2 роки тому

    This is the best explanation and visualization of how joins work on youtube - thank you!

  • @dalitsobotha7932
    @dalitsobotha7932 Рік тому +1

    Short, sweet and straight to the point... Great stuff!

  • @programmingwww
    @programmingwww 3 роки тому +12

    This guy explained joins and gave us perfect website about it 👏👏👏 Thank you!

  • @Ray-xl9iz
    @Ray-xl9iz 2 роки тому +1

    Best join guide ive seen, and i feel like ive seen dozens of them. Thank you

  • @fndfgbberb
    @fndfgbberb 3 роки тому +8

    Thanks Joma! The visualization is awesome for JOIN explanations. Totally stealing that haha

  • @Sebochan
    @Sebochan Рік тому

    You explained it in the best way possible. I hope we could see more of this (SQL) from you!

  • @mohamedsuhailirfankhazi6628
    @mohamedsuhailirfankhazi6628 6 місяців тому

    Very simple, concise and to the point. Exactly the way a tech tutorial is meant to be. Thank you!

  • @user-dc7oj3el7o
    @user-dc7oj3el7o 2 роки тому +1

    Hey Joma, this is the best explanation I found about Join so far! Thank you!!

  • @rubenkanya7342
    @rubenkanya7342 2 роки тому +17

    Very well done, you covered in 10 minutes what I never grasped in years! Well Done!

  • @milindsagar3630
    @milindsagar3630 2 роки тому +1

    I really love the way you teach, its just amazing.

  •  2 роки тому +2

    Awesome Joma, very clearly explained, keep the good SQL stuff content!!!

  • @krissstories5586
    @krissstories5586 2 роки тому

    OMG, I spent 2 weeks hitting my head in the wall. These 10 minutes made me understand that joins..... Thank you man

  • @michaelkalu918
    @michaelkalu918 Рік тому +2

    The most simplified and relateable tutorial on Join

  • @solojohno1
    @solojohno1 2 роки тому +1

    Outstanding video. Sub'd. This was explained so well that, by about 3 or 4 minutes into the video, I could anticipate the explanation of everything coming. And that's on a topic that I had previously found confusing. Nice work. I really appreciate it!

  • @ayoubbellaoui5833
    @ayoubbellaoui5833 2 роки тому

    simple and understood way to explain things that I have make me hate SQL one time but now anything is easy.
    Thank you !

  • @Rextirant
    @Rextirant 3 роки тому +6

    YOYOYO these be very educational, keep it up Joma!~!~

  • @rahulmahbubani1392
    @rahulmahbubani1392 Рік тому

    Best Video i have seen on joins, you did it better than any 1 hour video

  • @stol3nsoul504
    @stol3nsoul504 2 роки тому

    my teacher spend literally 3 full hours trying to explain this as complicated as he could, I didnt understand a single word. 10 minute video from you and boom i got it. Thanks so much buddy!!

  • @chrisnandasaputra2708
    @chrisnandasaputra2708 2 роки тому

    THANK YOU SENPAI, this is awesome!!!!!!

  • @Exceltech810
    @Exceltech810 Рік тому

    Omg. This video is veryyyyy clear for joins. Thanks you!! It's better than most of similar video about joins

  • @ghaziali3504
    @ghaziali3504 2 роки тому

    Interactive content and you made it so easy to learn! Thanks

  • @VeronicaAngryPolak
    @VeronicaAngryPolak Рік тому

    THANK YOU!! oh my gosh this finally set in, i finally get it after this video!!! thank you so much!!

  • @proCode10
    @proCode10 2 роки тому +1

    This is one of the best explanation videos I've seen on youtube.

  • @Roodementary
    @Roodementary 3 роки тому +1

    Thank you! This was 10 times easier than trying to read about it.

  • @backendadmin1217
    @backendadmin1217 9 місяців тому

    The way you explain things in detail is fabulous, you just made my day.... This video is most amazing on entire youtube.

  • @hanmuhammetbahtiyarov1644
    @hanmuhammetbahtiyarov1644 2 роки тому

    truly awesome! you made it look way easier than i thought, thank you

  • @001tolky
    @001tolky 2 роки тому

    That is the absolute best explanation I've found on this topic, print or video, including even Socratica's (which is saying something).

  • @yanivshabi288
    @yanivshabi288 2 роки тому

    It was very clear. Good job keeping it simple !

  • @FleeurFleeur
    @FleeurFleeur 7 місяців тому

    This was the best explanation I've heard! Thank you

  • @zayonnieves7035
    @zayonnieves7035 3 роки тому +1

    Fantastic explanation! Thank you so much for making it so simple and clear.

  • @Morexod999
    @Morexod999 2 роки тому

    Pretty good visualization of joining procedure, it gives more mean than just writting querys. Thank you, man, good presentation

  • @DanielLopez-gi8oy
    @DanielLopez-gi8oy 2 роки тому

    omg this video made me understand thissss. Finally, I love u man

  • @michealbailey6372
    @michealbailey6372 2 роки тому

    Man, great tutorial on joins. This explanation definitely helped my understanding on the subject.

  • @fg0611
    @fg0611 2 роки тому

    The best and simplest explanation about table joins in sql so far

  • @danielcortes4057
    @danielcortes4057 3 роки тому +2

    Thank you, it was very useful, cheers from Mexico!

  • @eliasalvarez6881
    @eliasalvarez6881 4 місяці тому

    Best JOINs video ever!!!

  • @shigriasif1316
    @shigriasif1316 3 місяці тому

    You did an amazing work. Before watching your video I haven't any idea about joins and Thanku so much for this content.

  • @missstella1584
    @missstella1584 2 роки тому

    Best video about joins so far

  • @melissaduran6319
    @melissaduran6319 2 роки тому +11

    I know people say this in nearly all programming/comp sci videos but yours was hands down the best explanation for this concept! I was only finding videos explaining the SQL but I am not learning that yet in my class so I didn't find it useful watching tutorials on it. Thank you so much for this detailed and thorough explanation!

    • @luisgaxiola-baqueiro6105
      @luisgaxiola-baqueiro6105 2 роки тому +1

      Exactly, I have seen these boring theoretical explanations which make me be more confused at the end than I was at the beginning, but this explanation is just easy and so well explained.

  • @iuliannegoescu9887
    @iuliannegoescu9887 7 місяців тому

    Best video !
    Thank you
    I understand all about joins!

  • @melvinwookiee2696
    @melvinwookiee2696 Рік тому

    I can't thank you enough... hands down the best video for beginnners

  • @siamimam2109
    @siamimam2109 2 роки тому +1

    I love how you explain!! Wish my professors were like u

  • @jafetcalderon9505
    @jafetcalderon9505 2 роки тому

    Man, this was so dam good!

  • @TheAjayTyler
    @TheAjayTyler 2 роки тому

    Fantastic job breaking this down 👍

  • @omyni
    @omyni Рік тому

    THANK YOU
    Sincerely,
    All visual learners everywhere

  • @itgetsdajobdone
    @itgetsdajobdone 3 роки тому

    Thank you for this quick refresher!!

  • @azhar6055
    @azhar6055 3 роки тому +1

    thank you Joma , this is extremely helpful

  • @mraprilonempeno
    @mraprilonempeno 2 роки тому

    This is really good explanation of joins. Thank you! 👏🏼

  • @alpha-mf9rh
    @alpha-mf9rh 15 днів тому

    The visuals are so helpful!

  • @gloriyathomas
    @gloriyathomas 2 роки тому

    The best intuitive explanation of joins! Thanks a lot..

  • @MdForhad-fy7vx
    @MdForhad-fy7vx Рік тому

    This is the video that um looking for...Thanks for this video

  • @bhushanssable9641
    @bhushanssable9641 2 роки тому

    The best video ever for joins ❤️

  • @codealong2456
    @codealong2456 2 роки тому

    WOW! thanks reading the same thing confused me a lot, just so easy this way!

  • @basavarajpatil9821
    @basavarajpatil9821 3 роки тому +1

    Great joma loved it

  • @hobbyboy218155
    @hobbyboy218155 3 роки тому +3

    Thank you for making this! Your explanation was clutch for my SQL exam tomorrow

  • @lppap9774
    @lppap9774 3 роки тому +2

    Hey man,
    This was the best explanation after so many videos. 💯
    THANK YOU!

    • @ahlamazam6211
      @ahlamazam6211 2 роки тому

      also tell good website for triggers ans stored procedures for visualization

  • @billnye7252
    @billnye7252 3 місяці тому

    Thank you so much for the easy to understand video. My a whole lecture of class understandable in 10 minutes. The visuals helped a LOT.

  • @Sean-uo9kw
    @Sean-uo9kw 3 роки тому +1

    Super informative and easy to watch. Thanks!

  • @hipman21
    @hipman21 Рік тому

    This is such an amazing explanation, so simple and clear! Thankyou

  • @rahulvaish3034
    @rahulvaish3034 3 роки тому

    Thanks for posting this video !!

  • @syhbeats
    @syhbeats 3 роки тому

    great video! helped me refresh my knowledge of joins!!

  • @tabithae3679
    @tabithae3679 2 роки тому

    This video is so helpful that I've come back to watch it 4 separate times.

  • @fahadjavaid7126
    @fahadjavaid7126 Рік тому +1

    You have explained these complex topics so nicely Cheers mate

  • @Milen.Yodanov
    @Milen.Yodanov Рік тому

    WOW
    that was amazing
    thanks brother!

  • @melsmakeup9133
    @melsmakeup9133 Рік тому

    Best video on youtube, thank you so much

  • @roman_mf
    @roman_mf Рік тому

    Great visualization, thank you so much :)

  • @caesarcastro9583
    @caesarcastro9583 Рік тому

    simple and straight forward. Thanks

  • @thatomotaung6891
    @thatomotaung6891 2 роки тому

    Such a good teacher, thanks for this.

  • @nymrod6620
    @nymrod6620 2 роки тому

    Great explanation Joma ! , You should consider doing the entire SQL

  • @djung8667
    @djung8667 3 роки тому +1

    Congrats for this very good video!!

  • @kukkakaali1751
    @kukkakaali1751 Рік тому

    Best explanation of joins that I've seen, finally understood it now :)

  • @tabithae3679
    @tabithae3679 2 роки тому

    This was SUPER helpful! Thank you! 🥺

  • @pauloxavier3033
    @pauloxavier3033 2 місяці тому

    Perfect explanation!! Simple and easy to understand!!

  • @ugonmaajie2240
    @ugonmaajie2240 8 місяців тому

    You're the best. Wow!!! I got it and well understood. ❤

  • @twoadventureus
    @twoadventureus 4 місяці тому

    Gold. Pure gold. lol Thanks for the summary. Great job!

  • @jaymanzoom
    @jaymanzoom 2 роки тому

    Didn't matter how I asked my teacher I couldn't understand what the hell the differences between the joins were. Thank you for making it so easy and showing visual examples.

  • @SzrIsTaken786
    @SzrIsTaken786 2 роки тому

    clutching me up in my databases class actual plug

  • @shubhampendbhaje9976
    @shubhampendbhaje9976 2 роки тому +1

    I'll mark this tutorial as the easiest amongst all out there... It was so easy to understand everything 😲

  • @JSunmonu
    @JSunmonu 11 місяців тому

    this was incredibly helpful thank you so much

  • @kalocsaymate8838
    @kalocsaymate8838 3 роки тому

    Damn so clear video and so underreated. Thank you.

  • @namphantech
    @namphantech Рік тому

    It's extremly visualize.I got uderstanding about all of type join in sql.Thanks bro

  • @hasanozdemir1067
    @hasanozdemir1067 2 роки тому

    Thank you so much for the video. It is super clear!

  • @hadidy13
    @hadidy13 Рік тому

    Thanks, that was as clear as day

  • @mzamomahaeng268
    @mzamomahaeng268 Рік тому +1

    I honestly couldn't visual understand this concept until your explanation 🙏🤗👍best ever explanation thank you

  • @natalevelardi1585
    @natalevelardi1585 2 роки тому

    Best explanation i've ever seen by far thank you!

  • @pranavkrishna6835
    @pranavkrishna6835 3 роки тому +2

    Amazing lessons brother 🔥🙏

  • @ridexdie4012
    @ridexdie4012 3 роки тому +1

    thank you for this, very helpful
    I refer back to the website from time to time

  • @iblove_b
    @iblove_b 8 місяців тому

    This was really helpful… thanks man

  • @zzang-boogie
    @zzang-boogie 2 роки тому

    한 번에 이해가네요. 고맙습니다

  • @shadynit
    @shadynit Рік тому +1

    this website you mentioned is perfect. Thanks

  • @gevon1520
    @gevon1520 Рік тому

    Thank you so much! I now understand it.

  • @robingrunsberg9572
    @robingrunsberg9572 2 роки тому

    Greatly explained! Thank you so much for saving my a** :D You've just earned a new sub!