Complete SQL JOINS For Beginners | SQL JOIN Queries with Examples | SQL Tutorial in Hindi 11

[@YourGirlPratiksha]

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!!

[@RishabhMishraOfficial]

Glad it helped! ✅️

[@nabinbist1220]

Hyyy

[@praveenjoshi928]

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 KZbin. Thanks.🙏

[@RishabhMishraOfficial]

Glad it helped! ✅️

[@nirvansadavarte9552]

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!

[@mdsarfaraz3794]

add on my words

[@debopriyomukherjee3400]

The visualizations and the effort you made to make us understand is truly appreciable sir. Understood the whole things very easily.

[@RishabhMishraOfficial]

Glad it was helpful ✅️

[@Sandipchaudhari-gz3ey]

this is the best explain i ever seen about sql. thanks for video

[@RishabhMishraOfficial]

Glad it was helpful! :)

[@AnnaPaul-zw3jd]

Whenever I came to you, never gone empty hand 😄, Tons of thanks

[@RishabhMishraOfficial]

Glad you liked the content ✅️

[@KamranHasanKhan]

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..

[@RishabhMishraOfficial]

Glad it was helpful ✅️

[@adityaneve3482]

thank you sir. aapne jo smjaya hai. sab ekdam dimag mai gya hai. or koi video dekhne ki jaraurat nahi padi.

[@sandeeprajput7697]

The way He demonstrate 🔥🔥 ## 2024 LIKE 👉👉

[@musicyouneed.5.2]

i was trying to learn joins bt no one was explaining properly....and thank god i found you

[@RishabhMishraOfficial]

Glad it was helpful, all the best :)

[@ashishvaghela9563]

Best explanation ever....isse simple way me koi sikha hi nhi sakta

[@RishabhMishraOfficial]

Glad you liked ✅️

[@hirdayram4437]

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

[@nishantvats905]

I found it by mistake, but this is awesome content on SQL. Thank you Sir for a very good explanation.

[@RishabhMishraOfficial]

Glad it was helpful! ✅️ keep learning n keep growing 🚀

[@poojababar8746]

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😇

[@mohdmuzammil9658]

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

[@RishabhMishraOfficial]

Glad you liked ✅️

[@ppriyansh2327]

tum bahut mast kaam karta hai Rishabh bhai Apun ko tumko thank you bolne ka hai

[@muhasawa]

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.

[@ShamimKhan.17]

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 ☺

[@anupam4446]

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

[@GAURAV-v9u]

AAJ MERA DOUBT CLEAR HUA YOU ARE THE BEST TEACHER ON KZbin.

[@RishabhMishraOfficial]

Glad it's helpful ✅️

[@rekhamalik3663]

One of the best videos on SQl i have found on KZbin. Thank you for such a great explanation

[@RishabhMishraOfficial]

Glad it was helpful! ✅️

[@lokendrachaudhary8170]

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

[@Travelling_With_Kamalu]

Rishabh bhai. i am fully understand this concept ( inner join ,Left join ,Right join ,Full Outer join ) Thanku again you are explanation osam ..........N/

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@khatrisinlondon2323]

Bhai bahot sahi tarike se samjhaya Joins ka concept with examples.....Thanks a lot...!!

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@nabinbist1220]

BEST VIDEO OVER ALL KZbin OF DBMS ...LOVE VAI. Yaisai batana you wiI'll be rise one day.. Wau animation ,diagram of example ..love you yr

[@RishabhMishraOfficial]

Glad you liked ✅️

[@akshara2929]

So simple to understand! Best video of joins on youtube

[@RishabhMishraOfficial]

Glad it was helpful! ✅️

[@AdnanKhan-db6eq]

Best explanation bro , My all doubts has been cleared related to join , Thanks for this video.

[@harshgaur_it_2864]

You explained these UNION concept in the most simplest way. Keep creating such content.👼

[@RishabhMishraOfficial]

Glad it was helpful ✅️

[@bhrtsinghal]

Well explained. Anyone can understand in this layman's language. Thank You so much :)

[@RishabhMishraOfficial]

Happy to help ✅️

[@Userm2040]

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 !

[@RishabhMishraOfficial]

Glad it was helpful ✅️

[@ayonghosh9154]

Jai Shree Ram, Thanks

[@omkarpharate9530]

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🙏

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@MuhammadWaseem-fw5tr]

Thanks bro Amazing explanation 💗

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@BanteeKumar-o5s]

You are just amazing.

[@alokraj1833]

sir kya koi condition false ho then hum koi msg print kr sakte hai SQL me? means ex:- agar customerID ko humne Primary Key banaya hua hai or 1 he customerID hum repeat kare to msg display ho ki "You entered a dublicate customerID" ?

[@Monika-c5n1y]

Thanks for sharing this video. Way of explaining is very simple and understanding. Thanks again

[@RishabhMishraOfficial]

Glad it was helpful! ✅️

[@vipinjadon7163]

Kya explain kiya. Hai sir with animation example .....,👌👌👌👌👌👌

[@RishabhMishraOfficial]

Glad you liked ✅️

[@ParasJain-s9o]

Sir your teach method is very good I seen this video first time and really i understand in first time

[@RishabhMishraOfficial]

Glad it was helpful ✅️

[@anishahamad5034]

Full join is not supported in MySQL. To achieve a full join, use a combination of LEFT JOIN and RIGHT JOIN with UNION to get the result of a full join

[@divyadarekar3939]

We do use mode of payment table in our DB so it became very much relatable and easy to understand..Thanks.❤

[@RishabhMishraOfficial]

Glad it helped ✅️

[@ankurprasad7842]

Very well explained. Thanks!!

[@RishabhMishraOfficial]

Glad it was helpful! ✅️

[@swadheenta.957VBTS]

You make it tooooo easy to understand sir thank you so much 💜

[@RishabhMishraOfficial]

Happy to help ✅️

[@कोकणस्वाद-भ6द]

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

[@RishabhMishraOfficial]

Glad you liked ✅️

[@yashdeeppal3120]

please make a video on creating cv for freshers in the field of data analyst

[@RishabhMishraOfficial]

Okayy noted ✅️

[@reon_fernandes]

Awesome video, your content was straight to the point. Thank you !

[@RishabhMishraOfficial]

Glad you liked ✅️

[@DanishKhan-u2c1l]

One of the best explanations I have ever seen, thank you, sir.

[@RishabhMishraOfficial]

Glad it was helpful! ✅️

[@shahrukhchaus0000]

Very very Thank you sir for teaching us Join Concept in very easy way...🙂

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@shashanksaxena6189]

thank you for such an easy explaination.

[@RishabhMishraOfficial]

Glad it was helpful! ✅️

[@shubham_paliwal]

Thank you sir for explaining so well! 💯

[@anishahamad5034]

nyc explanation keep it up... and make video on plsql

[@RishabhMishraOfficial]

Glad you liked ✅️ n noted

[@nishantnilay3242]

Column ke naam same nahi ho tab bhi chalega, values should be same

[@sayyadirfan5546]

i am unbale to upload the csv data file into table I am tried so many times but it shows process failed only. sir could you please help to how to upload the data file in table.

[@TJAYASHANKAR-n6u]

Suupperbb class sir❤, amazing video👌

[@RishabhMishraOfficial]

Glad you liked ✅️

[@hamzarauf320]

Outstanding Tutorial , I really appreciate your efforts and teaching methodology

[@RishabhMishraOfficial]

Glad it was helpful! ✅️

[@alokdeshpandey]

bahut badhiya se samjhae ho bhai

[@mdriyadakndo7429]

Greatful to you Best wishes and prayer Sir❤🧡

[@RishabhMishraOfficial]

Glad you liked ✅️

[@yogeshkumar8543]

Very well explained sir appreciate..mishra ji

[@RishabhMishraOfficial]

Glad you liked ✅️

[@codewithsaj9270]

Thanks. very easy to understand

[@RishabhMishraOfficial]

Glad it was helpful! ✅️

[@sawaimalhi8439]

great hain aaap tu sir sahi batya aap nay tu par joins zyda or kise samajin main jo joins chala rha hoon output sub ek jaisa he ah rha hai koi b change and nul nhe ah rha hai pata nhe kiyn aaap jaise synxt likhte hain waise he man likh rha hoon par output main msla ahrhay

[@anjalihingu8708]

The best explanation i have ever seen for joins

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@raiparshant]

More simple by your efforts

[@RishabhMishraOfficial]

Glad you liked ✅️

[@bodybuilding614]

Thankyou sir for best explanation 🎉

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@aparnaaras3531]

Best way of explanation Sir. Was very useful and easy to understand. Thank you Sir 😊

[@RishabhMishraOfficial]

Glad you liked ✅️

[@shubhamverma-fz8hq]

Pls make video on career guidance for bca

[@sayanbiswas770]

Maza a gaya bhai dekh ke, 🙏🙏🙏🙏. Animations were really helpful.

[@RishabhMishraOfficial]

Glad you liked it ✨️

[@rahulballal1084]

Very well explained sir and awesome presentation ....you made joins so simple & easy to understand

[@RishabhMishraOfficial]

Glad you liked ✅️

[@klavish7447]

Your teaching skills are amazing, thanks!

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@biswajitshaw3192]

U r awesome sir, way of explanation is simply best I have seen yet. Thank u so much and keep posting like this informative lessons

[@RishabhMishraOfficial]

Glad you liked ✅️

[@aishwarya687]

Too good. Thank you 👍

[@RishabhMishraOfficial]

Glad you liked ✅️

[@sachin6585p]

easy to understand thank you !!!!

[@RishabhMishraOfficial]

Glad it helped! ✅️

[@mathematicsbyshraddha5050]

Thanks bhaiya apne bahot acche se explain kiya thanks a lot !!

[@pawanpetkar5670]

Such an amazing explanation with Theory, Animation as well as practically query. Thanks Bhai

[@RishabhMishraOfficial]

Glad it was helpful ✅️

[@aakibkureshi2631]

Much appreciated

[@RishabhMishraOfficial]

Happy to help ✅️

[@mma-dost]

Great video really. Thanks a ton.

[@RishabhMishraOfficial]

Glad it was helpful! ✅️

[@sksdesi]

Hiii Rishabh....can you please make a full video on MS access????

[@RishabhMishraOfficial]

Okayy noted ✅️

[@sheetalmishra1258]

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?

[@RishabhMishraOfficial]

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;

[@SakshiChougale-l1s]

Very nice teaching sir 👍👍

[@RishabhMishraOfficial]

Glad you liked ✅️

[@robbysandhu4425]

Best explanation on Join.. Respect

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@shubhamraut3347]

thank you bhai best explanation ever

[@understandwithme5801]

Best explanation 👌 👏 Gr8 job

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@LifeOfChiran]

True hero bhai 👏

[@RishabhMishraOfficial]

Glad you liked ✅️

[@ayazqureshi5319]

Very well explained 🎉

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@kalravsharma4220]

Excellent explanation

[@RishabhMishraOfficial]

Glad it was helpful! ✅️

[@dipikazad3522]

very much helpful

[@RishabhMishraOfficial]

Glad it helped ✅️

[@sonisharma7757]

Marvelous explanation

[@RishabhMishraOfficial]

Glad you liked it

[@PranabhAsati2001]

good explanation of JOINS

[@sachinsutar8679]

mazing explanation with Theory, Animation as well as practically query

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@manishachauhan-xl9lx]

Sir please powerbuilder pe 1 video lekar aao mera interview h kuch dino ma please sir 🙏🙏🙏🙏

[@kanchankandari1675]

Thank you sir

[@umairhully5304]

Sir you are great 👍

[@RishabhMishraOfficial]

Glad you liked ✅️

[@shreyabhalgat9009]

appreciate the efforts,really clear and crisp explanation

[@RishabhMishraOfficial]

Glad it was helpful! ✅️

[@manishmaske8766]

Excellent and very easy to understand❤

[@RishabhMishraOfficial]

Glad it was helpful! ✅️

[@satyamayachak2000]

Bhai joins itna easily smjha diya mza aagya bhai❤❤❤

[@akshaymokal2863]

Very well explained. Great Job!!

[@RishabhMishraOfficial]

Glad it was helpful! ✅️

[@VaishnaviShah-nz7ff]

Thank you for this amazing explanation!!

[@RishabhMishraOfficial]

Glad it was helpful! ✅️

[@inshortview]

Today, I finally learned how joins actually work, I followed many videos and lectures but no one has taught like this bhaiya, keep updating and improving us, Thank you this helped me a lot bhaiya ❤❤

[@RishabhMishraOfficial]

Glad you liked it ✨️ all the very best brother 👍

[@inshortview]

@@RishabhMishraOfficial Bhaiya ek Data Analytics domain pe ek course or video lectures de do app, jisse aur clear ho jaye, Please

[@kirtisrivastava6352]

very useful . Your way of explanation is the best .

[@arupsarkar9733]

we can also use using for common column

[@talhaali5094]

Best lecture about SQL joins ❤

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@satadiptadutta1362]

Thank You Sir🙏

[@RishabhMishraOfficial]

Glad you liked ✅️