I was struggling with joins in SQL, but after watching this video I've completely understood it. This is by far the best explanation of Joins on RUclips. Thanks.🙏
I appreciate the effort you put into breaking down the complex concepts of joins and presenting them in a clear and easily digestible manner. Your explanations were detailed yet concise, making it much easier for me to grasp the nuances of inner joins, outer joins, left joins, and right joins. Thanks for this video man!
You do not know brother how much pressurize I was under, but really you r the hero of teaching, you always teach with basic ........ u do not know how happy i am....Thanks you so much..
I watched many videos, but I didn't understand anything ...this video make sense how to use joins... very good explanation ... thank you for this clear explanation😊...
bhai , aapne bahut badiya s smajhaya hai sabhi vdos m , honestly never felt ki aur koi vdo dekhni pdegi....... bhai meko syntax bahut badiya s samaz aat hai ... but, jb practicle kro toh error bahut aate hai .. koi sugesstion/opinion for beginners ??? to how to deal it ,fluently.......
Rishabh bhai. i am fully understand this concept ( inner join ,Left join ,Right join ,Full Outer join ) Thanku again you are explanation osam ..........N/
position depends on "payments p LEFT JOIN customers c" not on "c.customer_id = p.customer_id" , changing in "c.customer_id = p.customer_id" does not make any changes in output
Inner join : matching records from both the tables Left join : inner join + remaining records in the left table Right join : inner join +remaining records in the right table
super explanation you have explained it soo well with the diagrams that it is easy to remember the joins.. thank you sooo much .. keep uploading more videos on SQL
Thanks for the video, but one most important point that you should clear. The order in which columns are listed in the ON condition does not affect which table is considered the "left" table. The left table is determined solely by its position in relation to the LEFT JOIN keyword.
Please make a video on Subqueries problem solving in SQL. there is not available a single video on this topic well precise and Structured as u covered JOINS follow the same steps and please upload it. my doubts are perfectly cleared by watching this video thank you ☺
09:00 In joins, the column values should be the same. If column names are different, that doesn't matters. What matters is the values we are matching should be the same.
Very well explained joins. I'm a new learner you help me a lot to understand the inner joins also please give us more example if there's more than two table then how will use joins?
Glad you liked ✅️ Add one more join , example: SELECT student.first_name, student.last_name, course.name FROM student JOIN student_course ON student.id = student_course.student_id JOIN course ON course.id = student_course.course_id;
Hi Rishabh ! Just watched the full video 2 times. Thank you for your kindness and genorosity. Thank you for mentioning bits and pieces , detailed. God bless you !
13:08 Sir u made a small mistake here ig...The sequence of writing query after "ON" keyword doesn't actually matter...What matter's is Before "Left Join" keyword the mentioned table name will act as Left Table and after "Left join" keyword the mentioned table name will act as right table ...And it will remain same for Left join as well as Right join.
Sir..could you please make a video on how to prepare a report on SQL project after analysis or done with queries!! It would be really helpful for others too
All joints concept cleared today ,thanks for available such free course and the way you teach us that's in simple languages and easy to understand thanks again @Rishabh Bhai
Hi the video and concepts are awesome. only thing is customer id's are different in tables shown at 2:27 and tables created in workbench. So it confuses if somebody creates the tables just looking at the tables shown earlier in the video and hence the joins wouldn't work properly.
Sir apne bola tha ki left and right join me on ke bad dhyan rkhna h ki left table left side and right table right side honi chahiye but apne left and right tables ki query me on ke bad same hi rhne diya h
Is there any separate use case for both joins left and right as i can use any one join each time and just change the order of table in syntax?? why cant we use A.Key= null instead of is null? Btw amazing video sir sab smjh mai aa gya join ka to
Such an amazing explanation with Theory, Animation as well as practically query. I have seen lots of videos to understand this topic but no one can have a better explanation like this. Thanks a lot🙏
this is the best explain i ever seen about sql. thanks for video
Glad it was helpful! :)
I was struggling with joins in SQL, but after watching this video I've completely understood it. This is by far the best explanation of Joins on RUclips. Thanks.🙏
Glad it helped! ✅️
The visualization of joins is too accurate in this video. It helped me a lot to understand the whole concept and fix it in my mind forever. Thanks!!
Glad it helped! ✅️
Hyyy
Easiest explanation Rishabh brother.
I was scared of JOINS.
and now I learnt joins just within 21 mins.
Glad it was helpful ✅️
I appreciate the effort you put into breaking down the complex concepts of joins and presenting them in a clear and easily digestible manner. Your explanations were detailed yet concise, making it much easier for me to grasp the nuances of inner joins, outer joins, left joins, and right joins. Thanks for this video man!
Glad you liked it ✅️ n thanks for your encouragement 🚀
@pritamchougale looks like you pasted your comment directly from chat gpt😂😂
HI rishabh which Mike you used for vedio
Your way of explanation is too good it will be easy to understand specially for every beginner
This is what I expected from a person to teach and elevate me, not the other thing, I see this as a great thing.
Glad you liked
I am learning from chatgpt but first time I am satisfied with yt video
W3 par padhne jaa rha tha lekin you tube pe aaya socha dekh lu. To ap aa gye or pehli baar itna deeply join smj aaya hai
The visualizations and the effort you made to make us understand is truly appreciable sir. Understood the whole things very easily.
Glad it was helpful ✅️
So simple to understand! Best video of joins on youtube
Glad it was helpful! ✅️
This was my last video for SQL joins....
Totally understand in one go only 🙏
Thanks sir🙂🙂
Glad you liked ✅️
Me too
hands down the best video I have come across for learning SQL joins
Glad you liked ✅️
You do not know brother how much pressurize I was under, but really you r the hero of teaching, you always teach with basic ........ u do not know how happy i am....Thanks you so much..
Glad it was helpful ✅️
I watched many videos, but I didn't understand anything ...this video make sense how to use joins... very good explanation ... thank you for this clear explanation😊...
Glad you liked the content ✅️
I can bet iss topic ko koi isse jyada easy poore youtube mein koi explain nhi kiya hoga🙂. Your efforts are really appreciable
Glad you liked it ✅️
bhai , aapne bahut badiya s smajhaya hai sabhi vdos m , honestly never felt ki aur koi vdo dekhni pdegi.......
bhai meko syntax bahut badiya s samaz aat hai ...
but, jb practicle kro toh error bahut aate hai ..
koi sugesstion/opinion for beginners ???
to how to deal it ,fluently.......
Best explanation ever....isse simple way me koi sikha hi nhi sakta
Glad you liked ✅️
Thnqq soo much sir aaj tak joins ka topic koi shi se samjha nhi paya but apne kitne simple way m har doubt clear Kiya well done 👍 sir
Glad you liked ✅️
Whenever I came to you, never gone empty hand 😄, Tons of thanks
Glad you liked the content ✅️
i was trying to learn joins bt no one was explaining properly....and thank god i found you
Glad it was helpful, all the best :)
I think on YT nobody explained JOINS topic like the way you have explained. Gonna see all other SQL videos from your channel
Thanks for this tutorial😇
This is undoubtedly the best explanation of joins I have ever seen.
Glad you liked ✅️
The way He demonstrate 🔥🔥
## 2024 LIKE 👉👉
One of the best videos on SQl i have found on RUclips. Thank you for such a great explanation
Glad it was helpful! ✅️
AAJ MERA DOUBT CLEAR HUA YOU ARE THE BEST TEACHER ON RUclips.
Glad it's helpful ✅️
thank you sir. aapne jo smjaya hai. sab ekdam dimag mai gya hai. or koi video dekhne ki jaraurat nahi padi.
Samjhi me aa gya ak hi baar me thank you sir 👍
Glad you liked ✅️
Rishabh bhai.
i am fully understand this concept ( inner join ,Left join ,Right join ,Full Outer join )
Thanku again
you are explanation osam ..........N/
Glad you liked it ✅️
In 6:50 you stated that if column names in two tables aren't the same INNER JOIN wouldn't work. But that actually works. I have checked.
Bhai bahot sahi tarike se samjhaya Joins ka concept with examples.....Thanks a lot...!!
Glad you liked it ✅️
this is the best explanation on Joins in RUclips 🙌🏻🙌🏻🙌🏻🙌🏻🙌🏻.... God bless you sir thank you so much ❤🤗😇🤟🏻👏🏻✨
Glad it's helpful ✅️
position depends on "payments p LEFT JOIN customers c" not on "c.customer_id = p.customer_id" , changing in "c.customer_id = p.customer_id" does not make any changes in output
i was struggling to understand this in simple easy way , this is the best video
Glad it's helpful ✅️
tum bahut mast kaam karta hai Rishabh bhai
Apun ko tumko thank you bolne ka hai
Inner join : matching records from both the tables
Left join : inner join + remaining records in the left table
Right join : inner join +remaining records in the right table
super explanation you have explained it soo well with the diagrams that it is easy to remember the joins.. thank you sooo much .. keep uploading more videos on SQL
Glad it helped! Keep learning and growing 🚀
Mishraji, nicely done. As a QA its always hard to start on JOINS concept, but you made it very easy for me. Thank you so much..!!
Glad you liked it ✅️
You explained these UNION concept in the most simplest way. Keep creating such content.👼
Glad it was helpful ✅️
Thanks for the video, but one most important point that you should clear.
The order in which columns are listed in the ON condition does not affect which table is considered the "left" table. The left table is determined solely by its position in relation to the LEFT JOIN keyword.
Best and Simplest way to explain the typical topic of Sql .Thnankyou so much .🤗
Glad you liked ✅️
Please make a video on Subqueries problem solving in SQL. there is not available a single video on this topic well precise and Structured as u covered JOINS follow the same steps and please upload it. my doubts are perfectly cleared by watching this video thank you ☺
You teaching skill better than all college teacher bro very clearly explain each and every point with real world example god bless you brother ❤🤩
Aap mere college me as a teacher lag jaao plzz 😩👍
Aap kya krte ho
College m course
Tere college Wale afford nhi kr payege😂
Shi baat 😅😅@@AkashSingh-vloger
😂😂
Pyasa kuen ke pass jata hai, Kuan pyase ke pass nahi
Great Explanation i watch many vidoe on youtube of sql but you make my all doubt clear tnq❤
Glad it helped ✅️
Ya chez MN doond rhi thyi or khaii b smajh nhi arhi thyi thnku so much ❤
I found it by mistake, but this is awesome content on SQL. Thank you Sir for a very good explanation.
Glad it was helpful! ✅️ keep learning n keep growing 🚀
sorted the joins in SQL..Thanks!!
Glad you found it helpful ✅️
09:00 In joins, the column values should be the same. If column names are different, that doesn't matters. What matters is the values we are matching should be the same.
yes that's correct (y). values should match not column names- what i mentioned in the video was an example
Well explained. I was struggling to understand as I am a beginner but now its clear.
Glad it's helpful ✅️
Good❤❤
Well explained. Anyone can understand in this layman's language. Thank You so much :)
Happy to help ✅️
Very well explained joins. I'm a new learner you help me a lot to understand the inner joins also please give us more example if there's more than two table then how will use joins?
Glad you liked ✅️
Add one more join , example:
SELECT
student.first_name,
student.last_name,
course.name
FROM student
JOIN student_course
ON student.id = student_course.student_id
JOIN course
ON course.id = student_course.course_id;
bhai mujhe kisi bhi channel pe samajh ni aya..but u made it..thanks a lot
Glad it was helpful ✅️
Nice explanation it helped me in my work . Where I am searching chat gpt to understand really appreciated good visualisation and explanation 👍
Glad it's helpful! ✅️ Keep learning and growing🚀
Amazing explanation..I was struggling hard to understand the concept of sql joins but you made it very easy.. thanks a lot❤
BEST VIDEO OVER ALL RUclips OF DBMS ...LOVE VAI.
Yaisai batana you wiI'll be rise one day..
Wau animation ,diagram of example ..love you yr
Glad you liked ✅️
I didn't learned this concept from udemy but from your video Thank a lot
Happy to help ✅️
Honestly speaking I never came across such a great explanation. Keep up your great work sir 😊
Glad it's helpful ✅️
column name doesn't need to be same. As you are writing `ON c.customer_id = p.customer_id`, is it not already specifying which columns to match?
6:50
I was able to tackle first round of interview after this session..thank u .. ❤
Keep it up 🚀
Hi Rishabh ! Just watched the full video 2 times. Thank you for your kindness and genorosity. Thank you for mentioning bits and pieces , detailed. God bless you !
Glad it was helpful ✅️
13:08 Sir u made a small mistake here ig...The sequence of writing query after "ON" keyword doesn't actually matter...What matter's is Before "Left Join" keyword the mentioned table name will act as Left Table and after "Left join" keyword the mentioned table name will act as right table ...And it will remain same for Left join as well as Right join.
Kya explain kiya. Hai sir with animation example .....,👌👌👌👌👌👌
Glad you liked ✅️
Sir your teach method is very good I seen this video first time and really i understand in first time
Glad it was helpful ✅️
thank you so much, i was very confused after watching this video I completly understood.
Glad it's helpful ✅️
Sir..could you please make a video on how to prepare a report on SQL project after analysis or done with queries!!
It would be really helpful for others too
I think this is the perfect way of teaching. Keep doing great work
Glad it was helpful ✅️
How would I thankyou.
Your videos makes me believe that I can do it.
Thanks Rishab🎉❤
Glad you liked ✅️ to thank me it's very simple.. just get a good job 🚀
Thanks for sharing this video. Way of explaining is very simple and understanding. Thanks again
Glad it was helpful! ✅️
Best explanation bro , My all doubts has been cleared related to join , Thanks for this video.
Very very Thank you sir for teaching us Join Concept in very easy way...🙂
Glad you liked it ✅️
Thnkss sir this video eas really helpful. I did good at my exams
Glad to hear it helped! Keep practicing and learning. 💪
A very nice way to explain and good demonstration of joins.. Thanks👍
Glad it was helpful! ✅️
One of the best explanations I have ever seen, thank you, sir.
Glad it was helpful! ✅️
All joints concept cleared today ,thanks for available such free course and the way you teach us that's in simple languages and easy to understand thanks again @Rishabh Bhai
Glad you liked ✅️
Hi the video and concepts are awesome. only thing is customer id's are different in tables shown at 2:27 and tables created in workbench. So it confuses if somebody creates the tables just looking at the tables shown earlier in the video and hence the joins wouldn't work properly.
Thanks for the info!
Best way of teaching
Glad you liked
Outstanding Tutorial , I really appreciate your efforts and teaching methodology
Glad it was helpful! ✅️
Sir apne bola tha ki left and right join me on ke bad dhyan rkhna h ki left table left side and right table right side honi chahiye but apne left and right tables ki query me on ke bad same hi rhne diya h
Thanks bhaiya apne bahot acche se explain kiya thanks a lot !!
your videos are very easy to understand
Glad you like them! 👍
The best explanation i have ever seen for joins
Glad you liked it ✅️
simplify explained with easy language so good
Glad it was helpful ✅️
Awesome video, your content was straight to the point. Thank you !
Glad you liked ✅️
Thanks bro Amazing explanation 💗
Glad you liked it ✅️
Maza a gaya bhai dekh ke, 🙏🙏🙏🙏.
Animations were really helpful.
Glad you liked it ✨️
you have a calming personality, Sir. Good work.
Glad you liked ✅️
Very well explained sir and awesome presentation ....you made joins so simple & easy to understand
Glad you liked ✅️
sir please make a video on view database you explain very well so you make a video soon .😇
You're Genius, very well explained.
Glad it was helpful! ✅️
Is there any separate use case for both joins left and right as i can use any one join each time and just change the order of table in syntax??
why cant we use A.Key= null instead of is null?
Btw amazing video sir sab smjh mai aa gya join ka to
Best way of explanation Sir. Was very useful and easy to understand. Thank you Sir 😊
Glad you liked ✅️
thank you sir.. One of the best video for understand joins....
Glad you liked ✅️
Such an amazing explanation with Theory, Animation as well as practically query.
I have seen lots of videos to understand this topic but no one can have a better explanation like this.
Thanks a lot🙏
Glad you liked it ✅️
Yar excellent sequence ma video bnai ha bahtreen samaj aai ha A1
Glad you liked it ✅️
Such an amazing explanation with Theory, Animation as well as practically query. Thanks Bhai
Glad it was helpful ✅️
when there are duplicates present in any table, Will data repeat for duplicates in joins or not
Your teaching skills are amazing, thanks!
Glad you liked it ✅️
Thank you boss ❤ bahut shandar explain Kiya apne ❤
I have learned this in 5 semester but today i understoodd in 7th thankyou sir
Hiii Rishabh....can you please make a full video on MS access????
Okayy noted ✅️