Facebook – https://www.facebook.com/TheNewBoston-464114846956315/ GitHub – https://github.com/buckyroberts Google+ …
Original source
MySQL Database Tutorial – 23 – Outer Joins
Facebook – https://www.facebook.com/TheNewBoston-464114846956315/ GitHub – https://github.com/buckyroberts Google+ …
Original source
25 responses to “MySQL Database Tutorial – 23 – Outer Joins”
Great video, i have a question, i wanna know the info of 1 seller only, how can i show that??
Lots of Love and Respect for you Bucky!!
thank you. you helped me with settle some sql headaches with this one.
Nice tutorial 🙂 But SQL is such non-elegant, crappy language
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 😀
can you do a full outer join?
bucky's table
https://drive.google.com/file/d/0B9-DE8DcpkJ6T203YWFqS28wSFE/view
Awesome Explanation
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!
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
is'nt there any need of writing ON customers.id=items.sellers_id
Thank you for your videos, Bucky. Very helpful!
thank you and made it easy for us or for me. Thank you.
BUTHarry Potter's address is Diagon Alley :/
Thanks pal , you got my sub.
I always used to get confused with Left / Right and Inner / Outer joins. The way you explained it, it's brilliant!
excellent explanation !! got it in a sec.
Where's the table now Bucky
Bucky is the most influential person of the decade… Thanks for this tutorials !!
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!
mine is showing the Null's ,and I didn't used LEFT/RIGHT OUTER JOIN…I've used with the simple = sign,..oh well
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.
you have made my day! you made understanding this very simple. Thank you!
Nice Tutorial!
Why's the video so blury?