Have seen so many SQL videos on joins, no one has explained it like you. Will never forget the concept. Thanks so much for your hardwork and effort.

I never seen this kind of clear explanation. After 7 years I am clear join concept. Thank you so much.

The way you explain SQL even layman can understand SQL kudos to your explanation

Explanation is "at par". I don't think I'm gonna forget this JOINS concept in this lifetime. Thanks Taufiq !!

Salute Sir. I watched hundreds of videos on sql join but only ur video clear all concepts on Joins. Salute Sir.

I just came across this video, i figured out a internal logic of this on my own, did not know that this video existed. proud of figuring that out now

I generally dont comment on any videos, But I have to say i will never ever be confused about joins here onwards!! Gratitude!!

This is I suppose my first comment in years and years of using KZfaq. Just want to thank you provided such good explanation for joins . Thankyou ☺️

The way you explain joins is more concise than any of the SQL videos I've seen... I finally understand how Joins work .... thanks to your explanation..!

Before I was very confused with JOINTS but after watching the video with the formulas, examples and explanation I’m very much clear now. Hat’s off and thank you.

Sometimes topics are simple but you need a right guy to deliver it for you in a simple way. You got a subscriber ❤

I have seen quite a few videos on Joins but this is probably the simplest and easiest way of understanding Joins. Kudos!!! This will help in explaining joins in an Interview. Keep up the good work 😀

FORMULAS FOR JOINS 💢 INNER JOIN = Inner join will only fetch the matching record from the opposite table you mentioned. LEFT JOIN = Inner join + fetch any additional records from the left table which is not present in the right table. RIGHT JOIN = Inner join + fetch any additional records from right table which is not present in left table. FULL JOIN = Inner join + fetch any additional records from left table which is not present in right table + fetch any additional records from right table which is not present in left table.

I was searching for this type of join video with example from so many days . Thank you for how wonderfully u have explained...I didn't find anyone who is explaining like you... 🙏🙏

I have come across so many SQL joins video but this has very keen explanation ,we cannot forget that in life time Thank you for your valuable teaching

Nice explanation. Everyone should understand easily. Thanks fot uploading the vedio on joins

Sach ma phle bar mujhe join thik sa clear hua hai ...bahut bahut shukriya aapka....ma 3-4 video dekha pr utna badhiya samjha nahi ,,

Cannot be more comprehensive than this. Thank You so much, Taufiq.

The you explained is exceptional. I will never forget the concept of joins in my life.

After this video , no need to see other video on join concept, clear explanation, thank you 🙏

I feel so good that I have come across your channel. These small concepts are nowhere described in the way you have brought in front of us. So minutely explained and all the concepts are becoming clear day by day. Thank you so much for all that you are doing ❤

I swear to God this explanation of Joins is the best one I've ever watched

I was just watching this video randomly,just to brush up my concepts but I'd like to admit one thing for sure that when I learnt joins for the first time,I learned it in the Hard way.This is just some Brilliant stuff with extraordinary explanation👏

This is called a true education.... Thanks is a small word...❤❤

Please keep posting interview questions and concepts like these frequently..these are very helpful..and please start tutorials on power bi also if possible..❤️

Man you've explained exactly what i needed to know. You've no idea how relieved i feel after finally understanding the concept of joins. I needed to understand how sql works with each record of each table and you've explained that really well. Thanks a lot brother for this video. I'll definitely subscribe to your channel.

Most Helpful video ever. I have been trying to study SQL for the past 6 years and no one and I mean no one from Kudvent to Udemy Courses taught this concept so beautifully. Thanks a lot. can't thank you enough,.

You saved me!! I have faced this question so many times in interviews but the concept never got clear..this video is Messiah for me!

Thanks , searched for this content forever and finally after so long u made this video, one of its kind in most basic rules , really appreciate and please keep doing more of these videos, also nice that duplicate removing video has been made 😀

Thank you so much no one other has explained it so well it has been around 3 months i was learning SQL but got to know today that my understanding for inner join was very wrong . Feeling glad that i came across you tutorials

Hats off Toufiq. No one can explain better than this. We have a great teacher in the form you, who will help us with more information even for the small inputs which we have given to you. Kudos 👌👌🤞🤞. Thank you once again...

I bet no interviewer can confuse me with this sort of question anymore. Thanks TFQ!!

Seriously , You are best SQL teacher i have seen ever.

I got this same question in my interview 5 years ago!! 👍👍very good explanation! Thank you!

The way you explain the concepts it becomes easier to understand. which shows that the effort and hard work you put in to master the SQL.

Thank you so much for this explanation. Never understood joins better than this!!

I love how you explain how SQL works, It's so clear anyone can understand it. I'm hoping that your next video would be on SQL optimization?

best sql channel, I must say, I have failed the interview at noon, I wish i have seen your videos before the interview.

Have been seeeing so many sql videos to learn joins but no one can teach like this❤ kudoooooooos🎉

I have been so confused regarding when to use which one, this gave me so much clarity. Thank you for this wonderful lecture.

you are seriously oms , you are giving knowledge which is not present anywhere over the internet and about concept salute sir 🙋‍♂

Best video ever made to explain SQL joins in a very simple and subtle way. Thankyou.

This is one of the best videos on joins. I cannot thank you enough for this. 😊

This was seriously needed. After watching this video my all doubts in joins got clear .

No confusion, very well explained.

Much awaited video. Please also make some videos on optimization of SQL query.

Thank you so much Thoufiq .kudos this is the best explanation on KZfaq🎉. Will never these concepts going forward for sure after watching this. 🎉

I got exact idea on how joins are performed. I'm showing you gratitude sincerely. Thank you so much for this kind of explanation💥

Really awesome explanation, I was confused in Joins but you made it crystal clear sir. Thankyou, and keep posting more wonderful videos 😊

That was the best explaination, the formulas and how SQL works internally, thank you so much, please keep up the good work!

Awesome session @Toufiq! Ur videos are always really informative!! I was asked 2nd scenario in an interview & at that time, I did not know that 2 nulls are never same & I gave the wrong answer. 😒 Hats off! 👍💓😍😍😍😍😍😍

Very clear I came across many SQL videos but this one could able to understand the right concept.

seriously i have seen many videos on joins concept this the best video bro keep it up and THANK YOU

best way to explain joins i will never forget them in life time now

Your way of explanation is awesome sir. Thank you

Likes * Infinity. Very Simple and easy to understand. also providing the tables is a great idea as anyone can practice it without getting lazy to write insert query.

Bhai, video mast Laga🙏, all concepts are fully cleared. Love you bhai.... Laxmikant T.

What an explanation. I was looking for such video. Great💯

special teacher excellent teaching! we are lucky for watching your video brother

Really excellent teaching. 🎈🎁🎉 Vera level bro

Best ever video ….and literally now i am clear with this natural join …thank you for sharing.

You explained it really well I watched many videos but sometimes they confuse us but boss really hats off to you ... Hope you will make more such videos 😊

man this video was simply awesome ! made me super confident about joins for my upcoming SQL interview !

Much appreciated efforts. In my life, I will always remember the joins calculation :) . Thank you . Formula which u have given its Game changer :).

Hi sir, I was not able to get clear understanding about joins even I've watched and referred so many websites and KZfaq videos but finally I'm very glad and confident about joins after watching this video the way you explain with formula makes the whole scenario easy. Thankyou so much for making great efforts to make the concepts understand easily

Trust me i got this concept cleat after alot of months. Bro u rocks.

Asked similar question in my recent interview (inner, left, right, full outer, union, union all, intersect, minus). Thanks for sharing this video

Bro, you are amazing, I would agree to many commenters here, the way you have explained it , joins seem so easy to understand. Do come up with many more awesome videos like this. GLAD WE ALL FOUND YOU!! hooked now sir.. :)

Very simply way and with proper examples, joins are are explained here.Thanks for sharing.

Best explanation on KZfaq for Joins

Just say Wow. I have shared this video to many of my friends.

'techTFQ' My favorite SQL teacher.

Very clear no one can explain like you

Your content quality is very precise. Hope you run by this comment. Your contribution to the content world is much appreciated. Thankyou.

Very explanatory and reasonably short. Your videos are top ones. Great thanks!

Sir I Love your teaching the way you explained with good understanding English... Thanks

Toufiq ..u r a great teacher ...i literally enjoyed learning sql with you ...please make videos related to phython also

I have been looking out for this concept for a long time . Thank you for sharing this video

Ultimate video for joins. Excellent bro. 👏

After watching many videos I have concluded that this is a good and simple explanation on joins, it is easy to understand. thank you friend

This is my default question from last few years to all whom I interviewed to find if they are good at fundamentals.

Hi Sir, till now I had many confusions on Joins concept. But with your explanation my brain understood correctly, and I have created some examples like this, and I have answered the output correctly without writing the code. Thank you so much for clarifying this topic. If we can get this kind of explanations anywhere, I think we can have more coding developers right!!!!🤸‍♀🤸‍♀😎😎

I randomly find these video and after watching it was nice explanation and explain everything that was good no doubts remaining .Thanks

It was the best video on youtube related to joins, Thanks for the video

Best ever explanation I came across, on joins.

After watching this video i have cleared the join concepts. Thank You So much

Even the one who created sql can't teach better than you about these concepts tq bro

Wow amazing thank you for the explanation I finally understand the way Joins work!!!! I'm super excited and thankful thank you again!!

Finally cleared my concept of Joins. Thanks

The best explanation for SQL joins. Thank you for this video👍🏿

Thnk u so much♥️...I have my jio saavan interview coming up . This and ur other videos helped a lot .

the way you explain , i liked it. thank you so much. please keep posted more SQL interview question. it will help us to crack the interview.

You have explained SQL JOIN extremely well in details, thumbs up with thanks.

just stumbled onto your video.. Siifuuu!! abang, i owe you a good nasi lemak when i visit KL. terima kasih

Explained very clearly bro 😊 Till now no one explained like you thank you atlast found a good video

Bro, you're a lifesaver...

best video on youtube for joins..❤❤

Very Good Explanation, i have this doubt from many years, you have cleared this doubt easy way. Tha k you brother

Thank you soo much for wonderful explanation, Actually I came across that question in my interview but I'm not able to answer that, but now I have confidence to answer that kind of question.

Wow, wonderful! Thank you so much, extremely clear and deep explanation of the different JOINS. Thanx! :D