MySQL Database Tutorial – 23 – Outer Joins

[ad_1]
Facebook –
GitHub –
Google+ –
LinkedIn –
reddit –
Support –
thenewboston –
Twitter –


Posted

in

by

Tags:

Comments

26 responses to “MySQL Database Tutorial – 23 – Outer Joins”

  1. AJay Gupta Avatar

    for those of you who don't know, renaming a table or a column is known as alias.

  2. Edgar Hernandez Avatar

    Great video, i have a question, i wanna know the info of 1 seller only, how can i show that??

  3. AJay Gupta Avatar

    Lots of Love and Respect for you Bucky!!

  4. Harold Wright Avatar

    thank you. you helped me with settle some sql headaches with this one.

  5. Vinokanth Velu Avatar

    Nice tutorial 🙂 But SQL is such non-elegant, crappy language

  6. md apu Avatar

    Thanks Bucky, for the great tutorials, I know I'm very late here, but also upset to see that you didn't provided the database links in the video description Also your TNB thing is down. You should have then provided the links. I found those files in the video description but that not the table you changed in this video. Thanks.
    btw, your gf is cute 😀

  7. Lucy Kang Avatar

    can you do a full outer join?

  8. 291sc Avatar

    Awesome Explanation

  9. Gilbert Alphin Avatar

    I must say Mr. Roberts, coming from Microsoft Access' QBE, your explanation of "left and outer joins" are simple, clear and to the point!  Thanks!

  10. bigbeeforever Avatar

    2:02 you are basically showing the same id twice for each row so you could just use (SELECT i.seller_id, i.name) and all it does is show one less column and makes more sense. THANK YOU FOR THESE GREAT VIDEOS BUCKY HAVE BROUGH ME UPTO SPEED QUICKLY

  11. Abhishek Bhovad Avatar

    is'nt there any need of writing ON customers.id=items.sellers_id

  12. Cruz Baggio Avatar

    Thank you for your videos, Bucky. Very helpful!

  13. Wasim Bader Avatar

    thank you and made it easy for us or for me. Thank you.

  14. dalal hassan Avatar

    BUTHarry Potter's address is Diagon Alley :/

  15. Viktor Lekić Avatar

    Thanks pal , you got my sub.

  16. Sidhartha Chakravarty Avatar

    I always used to get confused with Left / Right and Inner / Outer joins. The way you explained it, it's brilliant!

  17. Lital Pelzman Avatar

    excellent explanation !! got it in a sec.

  18. Luis Andres Sanchez Avatar

    Where's the table now Bucky

  19. Toyin Popoola Avatar

    Bucky is the most influential person of the decade… Thanks for this tutorials !!

  20. Showbiz Avatar

    At school I was taught that joining tables shouldn't be done using the WHERE clause, instead you should use NATURAL JOIN, ON, or USING. But I guess it's just personal preference..

    Love the tutorials by the way, best on YouTube!

  21. Milan Borizovski Avatar

    mine is showing the Null's ,and I didn't used LEFT/RIGHT OUTER JOIN…I've used with the simple = sign,..oh well

  22. Lihim Sidhe Avatar

    The ON portion of the query could use more explaining.  I've gone through your entire javascript playlist and all the way up to here in your mySQL and this is the only thing I really couldn't wrap my head around.  You're still batting a 1,000 but yeah… no comprehende.

  23. Latavish Gardner Avatar

    you have made my day! you made understanding this very simple. Thank you! 

  24. vincentrich Avatar

    Why's the video so blury?

Leave a Reply

Your email address will not be published. Required fields are marked *