TABLE OF CONTENTS 00:00 - Intro 01:10 - INNER JOIN 04:20 - LEFT JOIN 07:03 - RIGHT JOIN 08:35 - FULL OUTER JOIN 09:36 - Optional OUTER Clause 10:38 - Alias the Join Tables 11:22 - Format SQL Join 11:55 - Filtering SQL Join in WHERE Clause 12:20 - Filter SQL OUTER Join in ON Clause 14:40 - Filter SQL INNER Join in ON Clause 15:30 - RIGHT JOIN can be changed to LEFT JOIN
@bridgerenzo68573 жыл бұрын
i dont mean to be offtopic but does any of you know a method to log back into an Instagram account..? I was dumb forgot my login password. I would appreciate any assistance you can offer me.
@lukalarry73493 жыл бұрын
@Bridger Enzo instablaster :)
@bridgerenzo68573 жыл бұрын
@Luka Larry i really appreciate your reply. I found the site on google and im trying it out now. Takes a while so I will get back to you later with my results.
@bridgerenzo68573 жыл бұрын
@Luka Larry it worked and I now got access to my account again. I am so happy:D Thank you so much you saved my account!
@lukalarry73493 жыл бұрын
@Bridger Enzo happy to help :D
@momentshub37736 жыл бұрын
Man, I watched like 6-7 video tutorials about Join in SQL. Your is the only one that I understood. Great explanation!
@ibrad.84356 жыл бұрын
Same with me!)))
@lazykitten43566 жыл бұрын
me too!
@abhisheshpandey20136 жыл бұрын
me too bruhh
@cesarrubio34125 жыл бұрын
Totally agree with you!
@symonxd5 жыл бұрын
facts
@diamondDog_6296 жыл бұрын
And I thought Joins were advanced concepts in SQL that I'm not yet ready to understand. God bless you Mr. Blue
@airstriker43664 жыл бұрын
Create View Transactions AS Select tbl_customers.Customer_ID, FirstName, LastName, Address, OrderDate, tbl_payments.Quantity, tbl_product.UnitPrice From tbl_transactions INNER JOIN tbl_delivery ON tbl_delivery.Delivery_ID = tbl_transactions.Delivery_ID INNER JOIN tbl_customers ON tbl_customers.Customer_ID = tbl_delivery.customer_ID
@clhk124 жыл бұрын
@@airstriker4366 print("Weird Flex, but okay...")
@danieldouglas33405 жыл бұрын
Great video! I got a much better grasp on SQL Joins in 18 minutes than I did in my instructor's 2.5 hour lecture. Thank you, sir!
@halildurmaz78273 жыл бұрын
Clear tutorial ! I cannot understand why the others make this topic hard to understand :) Especially the tiny tables you use, allows us to clearly observe what is happening
@user-bd4wc3oy8m6 жыл бұрын
I love your pacing. Not too fast or too slow. You're right in the goldilocks zone!
@Vpzoe5 жыл бұрын
Read 1-2 paragraphs from 3 different books in 2 mo. on joins. Today I said I'm going to get it. I come home, 18 min later, I'm good. Locked in. THANK-YOU-MR.-BLUE!
@stefanp.79865 жыл бұрын
he is a GOD.
@user-zz3qw9nr2p Жыл бұрын
This is by far the most helpful video I watched about Joins. So simple and straight to the point.
@PatrickburkeTVComedy6 жыл бұрын
Great video. The graphic and audio quality made this very easy to learn.
@AmitYadav-hn9rn5 жыл бұрын
Goodness, he is the only man who makes sense when it comes to explaining confusing joins, really good. Thanks
@4realentropyst2306 жыл бұрын
Spent an hour reading various tutorials and watching videos on this. Then you saved my nerves. This is by far the best and easiest explanation to SQL Joins I've ever seen, I can't thank you enough!
@JerodimusPrime5 жыл бұрын
This is the best SQL join explanation I've found on KZfaq. Thanks for your concise and understandable tutorial.
@bimsarademintha68454 жыл бұрын
Dude tomorrow is my DBMS exam for my diploma and you've probably saved my life. Hats off mate.
@arlenefvivaldi96775 жыл бұрын
Jesus, Thank You! I've used so many different sources and No one made it as straight forward as did you. Thank you :-)
@StefanoVerugi2 жыл бұрын
One of the best examples of how 15' video beats hours of manuals, lengthy presentations or, God forbid, expensive classes. Much appreciated.
@searez72513 жыл бұрын
As someone has said in the comment section, I have watched several videos to get a good grasp (concept) of the SQL joins, in my opinion this tutorial is the best tutorial I found. Simple, clear and to the point. Many thanks & God bless you!
@benjaminswindle5 жыл бұрын
I just started using SQL yesterday, and I already have a much higher level of understanding than a few of our developers, thanks Joey! Great series of videos!
@ZnSstr4 жыл бұрын
Finally a dude with a clean microphone, no stupid music and animations. I have been really rusted on sql, since I don't have that much experience either, this helped me a lot and I also learnt something new that you can filter ON clause and also you can use a where after the join.
@KiranPatel-gg6wt2 жыл бұрын
It only took me 12 years to understand joins. I was always afraid to touch this topic. Now I have some confidence. Thanks.
@GfastGao4 жыл бұрын
Exactlly the thing I need: 1. No BS agenda 2. no fancy context description 3. just thing about the topic and pitfalls I may encounter. Congrat, another good vid tutorial found!
@IamPali20243 жыл бұрын
Where has this dude been??!!! I have been developing for over 10 years, and I found this explanation to be coherent and clear as I was looking for a refresher on my SQL skills. thank man
@ahmedsehic90196 жыл бұрын
Many people post tutorials that are just confusing, yours is very clear Thanks Joey
@Monotoss5 жыл бұрын
I can't agree more with a comment, "Your is the only one that I understood". Same here. Absolutely brilliant explanation. Thanks so much Joey for making this awesome vids. You are the hero in SQL.
@RandjithKumar4 жыл бұрын
After a long time came here to have a quick glance about joins. videos from other channels was confusing. But your was much clear. Thanks a lot Joe.
@SS-bo9re3 жыл бұрын
This was hands down the best SQL join tutorial I've ever seen in my life! Keep up the good work!
@markgarrett29712 жыл бұрын
I have been trying to understand JOINS for the past hour and these 18 minutes broke it down perfectly. Thanks for your clarity!
@dushyanthkandiah37186 жыл бұрын
this video should trend on youtube
@bernardcyrus818911 ай бұрын
Hands down the BEST SQL tutorial on JOINs that I have seen! Makes clear sense!
@violetadyulgerova14464 жыл бұрын
Well after completing two courses on linked in learning and watching like 10 videos on KZfaq, I finally understood how to formulate join query and why do we use that = sign.Thank you so much for the clear, simple explanation!
@vespa7316 жыл бұрын
Thank you so much for this video! I've watched so many PowerPoint presentations and lectures and your video was the only one that actually helped me understand joins! Thanks again
@barysznikow2 жыл бұрын
Dear God, I was looking for someone who explain me how to use joins, and finally You sir made it clear and simple. Thank you!
@adivax34 жыл бұрын
You are the best teacher/instructor EVER!!! I dont know how you do it, but you make learning SQL so easy and enjoyable! Thank you!!!!
@georgecristianiordan37126 жыл бұрын
great man we owe you a lot, great explanations, great teacher!!!First I was learning without the app installed and I couldn't understand a thing, then I installed the Microsoft sql and I learned all your tutorials, I even created those tables that you show them in that video alone to understand better... Your are the best! thanks a lot.
@MrBauer734 жыл бұрын
Thank you Sir! You have made learning about Joins so simple. I spent hours reading through text books, trying to figure it out, and in less than 20 minutes you succeeded in making it clear to me.
@ekaterinaslavova23204 жыл бұрын
Finally a tutorial that made things simple and makes sense! Thank you!
@rufinosalgado41265 жыл бұрын
The clearest description of joins I've ever seen.
@samsbuzz92724 жыл бұрын
Thanks Joey..Really a simple and the best way of explaining Joins..The best part was the picture where you have shown putting the real tables in it and explaining it which has made it much more easier.Have tried so many videos to learn the concept but hands down you are the best..
@THE_joshbeoulve3 жыл бұрын
Thank you Mr. Blue. You succinctly explained in 8 minutes (didn't have to watch the whole vid) what my classroom teacher failed to teach in 45. More power to you, good sir.
@Rogueimgs4 жыл бұрын
Good job JB! I've felt like an idiot watching and reading my teachers instructions on joins but after your video I feel like its clearer. Mostly because you explain while showing the queries.
@muletowndumpsters4 жыл бұрын
The best SQL join video I've come across. Geewiz, everything else has been greek.
@kamransamoon90862 жыл бұрын
I am learning via coursera google course and then i got confused with joins. I watched several videos until I came to your video. I have understood now what JOIN is. Great video. Thanks for sharing. No words can express my appreciation for your work.
@DallasOakCliff6 жыл бұрын
This dude is the Michael Jordan of SQL vids.
@tdias254 жыл бұрын
LMAO
@JoshuaMusau2 жыл бұрын
The best explanation of SQL joins I have ever come across! God bless you.
@dejasbeautyxoxo13612 жыл бұрын
This was the best explanation of Joins. I appreciate you so much! other videos gave me an idea but this really helped me to comprehend and grasp the content. Thank you so much. You breaking this down step by step made a world of difference.
@Yegorich5 жыл бұрын
You are brilliant sir! I understood the concept of inner join as soon as your wrote your fist query. Thanks a lot !
@CoderSprint5 жыл бұрын
Special Salute. I went on with google for hours. In just 8 minutes you cleared all messed up things!!. Great Job. Thank you.
@nw7us4 жыл бұрын
As so many other people have written, your clear, paced explanation with demonstration really helped me solidify my handle on these basic concepts. I'm subscribing. Thank you for your efforts.
@lana16552 жыл бұрын
Thank you, this is so helpful. I couldn't understand my teacher, your video is 100% clear and on point. I literally have no questions. Really appreciate it. The quality is great too. I never thought that could be an issue in 2021, however, after viewing my teacher's recordings I realized that one must put an effort to make it this good.
@elenatsarapkina83114 жыл бұрын
How did other tutorials make it so over complicated? So much confusion with the other explanations. You are the best - real SQL GURU !!!
@KyleBrinkerhoff5 жыл бұрын
good lord that is so much more simple than what WGU teaches in their SQL class. you just saved me from so much friggen confusion
@Mous1325 жыл бұрын
40 minutes before my exams, you saved me ! Thanks !
@bunnyhei4 жыл бұрын
Thank you! I always find myself getting lost when people started talking about 'coding' or 'programming'.but your video is so well explained, and I understood what you have taught us. maybe i am not too dumb after all.
@OffbeatOracle4 жыл бұрын
Joey, all of you videos are super easy to understand. The visuals are great and you do great with the audio level. So many people upload videos where the audio is so low you can't hear it or it sounds like it's recorded in a box. Thanks for doing what you do.
@PlantBasedPietro3 жыл бұрын
I always had an idea of how the joins worked and usually experimented until I got the desired results. Now I fully understand the technique!!! Thank you Joey!!!!! :)
@RS250Squid5 жыл бұрын
My tutor took us through a one hour lecture on joins and a one hour classroom session and all that she did was confuse me hugely and make my head spin! You made this so simple and easy to understand. Thanks :-).
@manilakid35 жыл бұрын
Best explanation about SQL joins on the Tube. The others try to over complicate things to make themselves sound scientific which defeats the purpose of a tutorial. Thanks Joey.
@sazzadurrahman72934 жыл бұрын
Excellent video. I wasted a couple of hours using other resources. Only your video has helped me to understand how join really works
@mulugetakebede66514 жыл бұрын
i have been watching so many videos to understand this concept, yours is the only one that makes it so simple to understandable. Thank you so much
@user-yz5gn9ko8g5 жыл бұрын
god. this helped me so much on my assignment. I was looking at numerous videos and i couldn't understand any of those until i see yours. I'm so glad that this video exists. thank you so much.
@Nrgdumik Жыл бұрын
for real, this is the best tutorial on JOINS..Great explanation, thanks!
@isaacsmoli5 жыл бұрын
Congrats, two years later and continuous amazing. I can understand everything with your videos.
@jjones405 жыл бұрын
Good job. Finally... a video that clearly explains this topic. Thanks.
@satya121prakash3 жыл бұрын
I was searching EXACTLY this. My search ended here. Wonderful content.
@mgismondo6 жыл бұрын
I have to agree! After hours of what should be a simple straightforward just simple explanations I FINALLY hit your page! Well done sir!
@aaronmarks79126 жыл бұрын
Just stopping by to tell you - this is a great resource for folks who are new to SQL OR for developers who are trying to level up on SQL skills. Thanks for taking the time to make this!
@muhammadasim88735 жыл бұрын
10 Years of using Excel... Well Versed in using DAX... but never understood SQL Joins.... But this video changed it all... Thanks Joey... May Allah Bless you.... would love if you could start a DAX Series as well.... Thanks in advance....
@singhpad15 жыл бұрын
Thank you for your in-depth explanation for novices like me. Really appreciate it.
@imanqoly4 ай бұрын
After a long long time of procrastinating to understand the joins, finally, thanks a lot
@lorismiths69515 жыл бұрын
This was the first video I saw of Joey's SQL series, and I must say I'm hooked. I was going to watch the 1hr beginning video. But, I'm very glad I watched this one first. Extremely helpful and look forward to watching all the videos in the series. Just a tip for anyone who is new to T-SQL (Microsoft) or SQL in general. I would personally practice the JOINS he talks about. And even come back, and watch the video a couple times to really help it stick. Again amazing video thank you!
@isaacvallejo63334 жыл бұрын
This really helped. From reading to watching other tutorials. This one was broken down perfectly and easy to understand thanks!
@alexandreabarbosa5 жыл бұрын
Awesome! Straight to the point! Correct and excellent explanation!
@juliusguevarra37293 жыл бұрын
Thanks for explaining it very clearly. Out of all the videos that I watched regarding this topic, only yours made it all sense to me!
@randomguy-dd6mn2 жыл бұрын
thank you so much for this, I don't think I would be able to the thing I wanted without this
@kanikamaheshwari97323 жыл бұрын
This is the most simplest explanation for anybody. Great work sir. Thank You.
@kitta753 жыл бұрын
Very good one & helpful. Simple and easy to understand in few minutes
@luckyduck23459 ай бұрын
I like how simply you explained this. Was the exact video I was looking for. Thanks a bunch!
@thejancis384 жыл бұрын
I always thought this is hard, and I've never tried to learn this. After watching this video and trying it out, it's actually pretty simple and very useful! Thank you!
@speakup28884 жыл бұрын
I wish I had a teacher like you in my school. God Bless You!
@amralkhatib50315 жыл бұрын
the explanation better than the explanation in my language. thanks man
@vedatduhadaglar9603 жыл бұрын
The way he explains it is so clear. Really well done
@JohnSmith-hn6kv6 жыл бұрын
This is probably the best Join video I've watched. Caleb should watch your videos for production values inspiration!
@nyanners81065 жыл бұрын
Good work, spoken in the language of the people!
@MostafaMASLOUHI4 жыл бұрын
This is the first time I understand these stuffs. THANK YOU
@FinallHit4 жыл бұрын
I struggled alot with joins.. and now im like "thats it??" Great explantion!
@igorsmet11234 жыл бұрын
Literally the most straightforward video I could find, thank you so much. Now all those joins make perfect sense. 🙌
@specificgravity-thedancing97002 жыл бұрын
Super helpful!! I doubt there is a better way to explain this. Extremely good video!!
@khookhalshehri91074 жыл бұрын
Many thanks really the best channel in SQL tutorials
@ellyjessy50445 жыл бұрын
I'm now more confident after watching your videos. Great teacher indeed.
@resulrustemi83303 жыл бұрын
i watched over 20 videos and finally i found this video . very well explained 😉
@johng52952 жыл бұрын
Thanks in a million! Very well explained. This is the nth time that I am watching this again. Great content. Awesome. I couldn't find this explanation--simply put anywhere else. “Great teachers are hard to find”. Grade: A++ 💥
@hannav71253 жыл бұрын
Thank you Joye your voice is so calm and relaxed to listen too. This is extremely helpful.
@kopilkaiser8991 Жыл бұрын
Brilliant tutorial. You were right on the spot to explain about this topic. It was really easier to understand SQL joins thanks to you
@igordjurdjic73806 жыл бұрын
Thank you for your great explanation, only this video showed me what each Join do. Bless you
@mariaelenarebolledo86963 жыл бұрын
Nice! Straight to the point on SQL JOINS and the explanation is very clear. Thank You!
@decandanny51034 жыл бұрын
This video helped me to understand sql joinings.Thank you!😀..good job! Keep on uploading videos.
@mattmattelig4 жыл бұрын
using the venn diagrams to explain the concept was genius. Thank you for your great tutorial. thumbs up
@ABHIJEETSINGH-gm6te5 жыл бұрын
i would recommend this channel to everybody.
@xiesherry86245 жыл бұрын
That's really helpful. I think it's better than the on-site SQL course. Internet provides great sources. We should make good use of it.
@ShaolinMonkster4 жыл бұрын
Ok, these are the best tutorials on the internet. I'll watch all your playlist and then go ahead and buy your udemy courses.
@owaisattaey29473 жыл бұрын
Thank you Mr. Blue. Very well explained with the visual examples.