Facebook – https://www.facebook.com/TheNewBoston-464114846956315/ GitHub – https://github.com/buckyroberts Google+ …
Original source
Facebook – https://www.facebook.com/TheNewBoston-464114846956315/ GitHub – https://github.com/buckyroberts Google+ …
Original source
36 responses to “MySQL Database Tutorial – 22 – How to Join Tables”
wtf is this shit? he didn't even make a join query… this vid is useless
why didn't you use the left join function?
Can I put the joined tables together into a Permanent table?
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!
Wow!! You explained it so well 👍👍
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 🙂
Wow, you have a really good way of explaining the logic of the sql world. Thanks for the video !
This guys knowledge knows no bounds!!
Tunafish lane 🙂
in the query at 6:29, is it also correct to write:
WHERE customers.id = items.seller_id?
Why can't production databases be this entertaining?
No bids for id=2 ? ( ͡° ͜ʖ ͡°)
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
Thank you so much Bucky your tutorials made it so easy to understand than those hours long lecture.
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.
on equal operator you have to specify customers.id = items.seller_id
Hey guys, a little help over here.
Where can I download the tables that Bucky is using?
Thanks a lot.
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.
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.
joins are probably the trickiest part of mysql. thanks for explaining
Thank you sir ,Your vidio is really helped me
is that customers are sellers at the same time? I dont understand how can customer id equals to sellers id.
fuck u robertsfuck u robertsfuck u robertsfuck u robertsfuck u roberts
20 seconds 8 minutes. wut
Thank you! Amazing.
This really helped me out with a custom query I needed for a site. Thank you for posting!
i want to join 3 tables together, pls i need help
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!
Anyone else laugh at "used diaper from my sister"?
You helped me out a LOT. Your whole youtube page is great for learning some stuff before a test. Thank you ^^
Very well explained.
SIMPLYYYYYY AWESOME……: -)
So many videos out there on joins. This one is my favourite!
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
can I put AND statement after the WHERE clause to put another related tables?
very good explanation. very clear and easy to understand