• Tuesday , 19 September 2017

MySQL Database Tutorial – 22 – How to Join Tables

Code Canyon



Facebook – https://www.facebook.com/TheNewBoston-464114846956315/ GitHub – https://github.com/buckyroberts Google+ …

Original source

3d Ocean

Related Posts

36 Comments

  1. RazieL
    June 26, 2017 at 01:38

    wtf is this shit? he didn't even make a join query… this vid is useless

  2. legitmontrellthigpen
    June 26, 2017 at 01:38

    why didn't you use the left join function?

  3. vJDiZZ
    June 26, 2017 at 01:38

    Can I put the joined tables together into a Permanent table?

  4. Tina x
    June 26, 2017 at 01:38

    I've looked at a lot of MySQL videos, and this video has very good explanations. Also, its nice that you have some humor too. Thanks!

  5. Rimpy Pannu
    June 26, 2017 at 01:38

    Wow!! You explained it so well 👍👍

  6. Cosor Alexandru
    June 26, 2017 at 01:38

    SELECT `customers`.`id`, `customers`.`name` AS `customer`, `items`.`name` AS `item`, `items`.`cost`
    FROM `customers`
    INNER JOIN `items`
    ON `customers`.`id` = `items`.`seller_id`;

    A more valid syntax 🙂

  7. Mads Hansen
    June 26, 2017 at 01:38

    Wow, you have a really good way of explaining the logic of the sql world. Thanks for the video !

  8. steven lane
    June 26, 2017 at 01:38

    This guys knowledge knows no bounds!!

  9. Kliamframe
    June 26, 2017 at 01:38

    Tunafish lane 🙂

  10. Phil
    June 26, 2017 at 01:38

    in the query at 6:29, is it also correct to write:
    WHERE customers.id = items.seller_id?

  11. Savage Noble
    June 26, 2017 at 01:38

    Why can't production databases be this entertaining?

  12. vnodkumar1987
    June 26, 2017 at 01:38

    No bids for id=2 ? ( ͡° ͜ʖ ͡°)

  13. Devin Gaferno
    June 26, 2017 at 01:38

    Great tutorial! I would also like to know if its possible to turn the results into a new table in the database display on a site using php. Thank you

  14. Jay Suthar
    June 26, 2017 at 01:38

    Thank you so much Bucky your tutorials made it so easy to understand than those hours long lecture.

  15. FleurOlivia
    June 26, 2017 at 01:38

    Omg I finally get this now thank you, I should mention you in my graduation speech. If I ever complete Computer Science it will be solely because of you.

  16. Saurav Pati
    June 26, 2017 at 01:38

    on equal operator you have to specify customers.id = items.seller_id

  17. Pablo Cid
    June 26, 2017 at 01:38

    Hey guys, a little help over here.
    Where can I download the tables that Bucky is using?
    Thanks a lot.

  18. Viktor Lekić
    June 26, 2017 at 01:38

    Thank you , tutorial is very clear . I have hearing problem and I couldn't understood a single word you were speaking , but I know this now.

  19. Vu So
    June 26, 2017 at 01:38

    What happens when the WHERE statement specifies two columns that have completely different information/does not match? Depending on the column I choose, I can get some output (instead of empty set) and trying to figure out why that is since the columns have different information.

  20. candh
    June 26, 2017 at 01:38

    joins are probably the trickiest part of mysql. thanks for explaining

  21. Jitendra Sahu
    June 26, 2017 at 01:38

    Thank you sir ,Your vidio is really helped me

  22. Gino
    June 26, 2017 at 01:38

    is that customers are sellers at the same time? I dont understand how can customer id equals to sellers id.

  23. not my real name. screw googleplus
    June 26, 2017 at 01:38

    fuck u robertsfuck u robertsfuck u robertsfuck u robertsfuck u roberts

  24. not my real name. screw googleplus
    June 26, 2017 at 01:38

    20 seconds 8 minutes. wut

  25. Mihail Georgescu
    June 26, 2017 at 01:38

    Thank you! Amazing.

  26. Jeremy Tews
    June 26, 2017 at 01:38

    This really helped me out with a custom query I needed for a site. Thank you for posting!

  27. horlakunle23
    June 26, 2017 at 01:38

    i want to join 3 tables together, pls i need help

  28. Peristilo peris
    June 26, 2017 at 01:38

    It's been a long time since I watched a Buck's video for the first time, but the feeling remains the same: you're the best, man!

  29. Vector Vent
    June 26, 2017 at 01:38

    Anyone else laugh at "used diaper from my sister"?

  30. JowelleK
    June 26, 2017 at 01:38

    You helped me out a LOT. Your whole youtube page is great for learning some stuff before a test. Thank you ^^

  31. nemnoton
    June 26, 2017 at 01:38

    Very well explained.

  32. CHETAN BANKAR
    June 26, 2017 at 01:38

    SIMPLYYYYYY AWESOME……: -)

  33. david crowley
    June 26, 2017 at 01:38

    So many videos out there on joins. This one is my favourite!

  34. Billy Piazza
    June 26, 2017 at 01:38

    you are the man. i've been knocking myself out for 24 straight hours trying to figure out my query and you nailed it in 8 minutes! i am in ore of you lol

  35. dennis noriega
    June 26, 2017 at 01:38

    can I put AND statement after the WHERE clause to put another related tables?

  36. Latavish Gardner
    June 26, 2017 at 01:38

    very good explanation. very clear and easy to understand

Leave A Comment

You must be logged in to post a comment.