MySQL #36: SQL JOINS In One Video In Hindi | INNER, LEFT, RIGHT JOINS in MySQL

Welcome, MySQL Joins Tutorial in SQL in Hindi. Inner Join, Left Join, Right Join. SQL JOIN in Hindi. A JOIN clause is used to combine rows from two or more tables, based on a related column between them.
Different Types of SQL Joins
Here are the different types of JOINs in SQL:
(INNER) JOIN: Returns records that have matching values in both tables
LEFT (OUTER) JOIN: Returns all records from the left table, and the matched records from the right table
RIGHT (OUTER) JOIN: Returns all records from the right table, and the matched records from the left table
FULL (OUTER) JOIN: Returns all records when there is a match in either left or right table
Click here to watch video on
➡️ 50% OFF on Domain & Hosting: • WHAT IS DOMAIN AND WEB...
➡️ Follow me on Instagram: / vinodthapa55
Must Watch Videos For Web Development.
➡️ HTML in One Video: • Learn HTML in One Vide...
➡️ CSS in One video: • Learn Complete CSS In ...
➡️ JavaScript in One video: • JavaScript in One Vide...
➡️ ECMAScript 6 in One Video : • ES5 & ES6 | ECMAScript...
➡️ HTML5 in one video: • HTML5 Tutorial in One ...
➡️ CSS3 in one video: • Learn Complete CSS3 In...
➡️ Bootstrap4 in One video: • Bootstrap 4 in One Vid...
➡️ Jquery in One video: • jQuery in One Video in...
➡️ JSON in one video: • JSON in One Video in H...
➡️ ReactJS in one video: • ReactJS For Beginners ...
➡️ PHP in One Video: • PHP TUTORIAL IN ONE VI...
➡️ NodeJS in one video: • Node.JS in One Video i...
➡️ MySQL in one video: • Complete SQL & MySQL i...
DONATION FOR SUPPORT: PhonePay = vinodbahadur@ybl GooglePay: vbthapa55@oksbi
Believe me, all this money will be used to make more quality videos and to make my channel grow. So that I can always provide you awesome free videos :)
My Siter UA-cam Channel Link: www.youtube.co....
Plz Subscribe with all your friends :) Thank You.
click on the link below to watch web developer courses videos
HTML in One Video : • Learn HTML in One Vide...
CSS in One Video: • Learn Complete CSS In ...
Javascript tutorial in one video: • JavaScript in One Vide...
PHP in One Video: • PHP TUTORIAL IN ONE VI...
DAtabase and PHP Together for read, create, update, delete: • CRUD Operation in PHP ...
How to create a website like carbon health: • Create a Complete Resp...
How to create a website: • Create Responsive Webs...
Tools I used to record videos
1: Dell Inspiron 15 5570 2018 15.6-inch FHD Laptop (8th Gen Core i3-8130/4GB + 16GB Optane Memory/1TB/Windows 10): amzn.to/2DErOoG
2: Wright WR 800 Condenser Microphone with Free USB Sound Card: amzn.to/2TjRUmc
3: Wright Wp 101 Pop Filter For Dynamic Condenser Microphone Voice Recording: amzn.to/2B67lro
4: AmazonBasics Ventilated Laptop Stand (Black): amzn.to/2DDs1Zd
5: Generic NB-35 Professional Recording Microphone Stand: amzn.to/2HBDbC1
6: JBL T160 in-Ear Headphones with Mic (Black): amzn.to/2HwbJp0
7: AmazonBasics Braided HDMI Cable - 6-Feet: amzn.to/2TkCTkc
Guys, Please support my channel by SUBSCRIBE to my channel and share my videos in your Social Network TimeLines.
Don't Forget to Follow me on all Social Network,
Website Link: www.thapatechn...
Instagram Link: / vinodthapa55
Facebook Link: / vinodthapa55
Twitter Link: / vb55thapa
Facebook ThapaTechnical Page Link: / vinodbahadur. .

[@ThapaTechnical]

BUY DOMAIN & HOSTING AT 50% OFF.. Click here to watch video on
➡️ 50% OFF on Domain & Hosting: ua-cam.com/video/Mr-3iEiX6xg/v-deo.html
➡️ Follow me on Instagram: instagram.com/vinodthapa55/
Must Watch Videos For Web Development.
➡️ HTML in One Video: ua-cam.com/video/pN7BFLfSjFw/v-deo.html
➡️ CSS in One video: ua-cam.com/video/hkQv0NIxKQY/v-deo.html
➡️ JavaScript in One video: ua-cam.com/video/PODgPW-hbfU/v-deo.html
➡️ ECMAScript 6 in One Video : ua-cam.com/video/Iek4DtRobLA/v-deo.html
➡️ HTML5 in one video: ua-cam.com/video/4V0-YpO-KZo/v-deo.html
➡️ CSS3 in one video: ua-cam.com/video/TFrFx7H5ZI8/v-deo.html
➡️ Bootstrap4 in One video: ua-cam.com/video/yZnNnvXO8HI/v-deo.html
➡️ Jquery in One video: ua-cam.com/video/PNvyPEQ0y-I/v-deo.html
➡️ JSON in one video: ua-cam.com/video/bMqevPKAPD4/v-deo.html
➡️ ReactJS in one video: ua-cam.com/video/43IbFDSVdB0/v-deo.html
➡️ PHP in One Video: ua-cam.com/video/3024Kc6SDJ0/v-deo.html
➡️ NodeJS in one video: ua-cam.com/video/ipnWAKoiBtY/v-deo.html
➡️ MySQL in one video: ua-cam.com/video/5bFxbwjN-Gk/v-deo.html
DONATION FOR SUPPORT: PhonePay = vinodbahadur@ybl GooglePay: vbthapa55@oksbi
Believe me, all this money will be used to make more quality videos and to make my channel grow. So that I can always provide you awesome free videos :)
My Siter UA-cam Channel Link: ua-cam.com/channels/Est.html...
Plz Subscribe with all your friends :) Thank You.
click on the link below to watch web developer courses videos
HTML in One Video : ua-cam.com/video/pN7BFLfSjFw/v-deo.html
CSS in One Video: ua-cam.com/video/hkQv0NIxKQY/v-deo.html
Javascript tutorial in one video: ua-cam.com/video/PODgPW-hbfU/v-deo.html
PHP in One Video: ua-cam.com/video/3024Kc6SDJ0/v-deo.html
DAtabase and PHP Together for read, create, update, delete: ua-cam.com/video/y5mBHPtEO5w/v-deo.html
How to create a website like carbon health: ua-cam.com/video/W21rnDn8L9U/v-deo.html
How to create a website: ua-cam.com/video/yfYch-HerV4/v-deo.html
Tools I used to record videos
1: Dell Inspiron 15 5570 2018 15.6-inch FHD Laptop (8th Gen Core i3-8130/4GB + 16GB Optane Memory/1TB/Windows 10): amzn.to/2DErOoG
2: Wright WR 800 Condenser Microphone with Free USB Sound Card: amzn.to/2TjRUmc
3: Wright Wp 101 Pop Filter For Dynamic Condenser Microphone Voice Recording: amzn.to/2B67lro
4: AmazonBasics Ventilated Laptop Stand (Black): amzn.to/2DDs1Zd
5: Generic NB-35 Professional Recording Microphone Stand: amzn.to/2HBDbC1
6: JBL T160 in-Ear Headphones with Mic (Black): amzn.to/2HwbJp0
7: AmazonBasics Braided HDMI Cable - 6-Feet: amzn.to/2TkCTkc
Guys, Please support my channel by SUBSCRIBE to my channel and share my videos in your Social Network TimeLines.
Don't Forget to Follow me on all Social Network,
Website Link: www.thapatechnical.com
Instagram Link: instagram.com/vinodthapa55
Facebook Link: facebook.com/vinodthapa55
Twitter Link: twitter.com/vb55thapa
Facebook ThapaTechnical Page Link: facebook.com/vinodbahadur...

[@manojkumarjaiswal4664]

66yÿ 6y6t5t6

[@awaraghumkaddeewana4059]

Coaching chaiya mhuje apse

[@hussainansari3854]

University k 4 saal nahi sikha aj ja k sikha or bhai ne behtreen sikhaya

[@theindiangamer3226]

😂

[@sahilvance5838]

Meri to 12th me h ye🙃

[@prakharchoudhary3838]

Bhai University me padhai kiye rehte to sikhe rehte

[@hussainansari3854]

@@prakharchoudhary3838 chup be brahma beti chod k man ne walay

[@Deekshasharma24]

Mujhe abhi tk bhi aaya 😢

[@nikhilsahdev1108]

I am watching this video in 2023 and thank you for clearing my doubts, My mind was totally messed up but after watching your video and implying it on practical bases it works. thanks a ton.

[@saurabhverma25]

Thank you for giving us a perfect example & also giving us a perfect defination of all type of join.
Thank you so much.

[@Engineer_kida]

thank you for clearing my doubts, My mind was totally messed up but after watching your video and implying it on practical bases it works

[@icodeideas_]

Concepts clear in 20minutes. Thank you so much for your awesome video

[@manasgain]

2 saal baad jaake...Join ka concept clear huaa.
Thank you

[@gauravgaurav6055]

Thanks!

[@Deleted12347]

Thanks bhai, I will share this video with my friends

[@VloggySaurav]

thapa jyu, tapaile saro mitho padawnu bhayo haw, ekai khep ma sabai kura clear bhayo.
thapa jyu sakinxa bhane data science sambhandi pani video banawnus hola hai..
dhanyabad..

[@meghapengoria77]

Very well explained..You nailed it thanks you for this video

[@willturner3440]

Vaah ek baar me join khatam, hats off to thapa bhaiya

[@monikatanwar4211]

Thanks for short n sweet material🤗🤗

[@hrithikahuja7663]

Brilliant teaching sir,solved each and every problem of mine in joins

[@arnavgupta7392]

right join can also be useful when u consider customers table as the right table .......nice video

[@kidzzone441]

🎉🎉🎉

[@rishabhyadav1898]

Excellent video.
Thank you sir👍👍

[@shehzadafzal658]

Method of teaching is so good sir

[@SMHasan9]

Thanks a lot

[@shitalawchar9086]

Thanks sir

[@coderbravo1275]

Thank You. Thapa Sir.. Much helpful video 👌🏽 #KeepItup✔︎

[@Monika_choudharyy]

Superb concept clear in just 20 minutes.
Thanks

[@archanachaudhari7546]

Tnx...Your video helps a lot

[@This__is__akash]

A very elegant explanation ..

[@bhushanambhore8378]

Thank you sir ji

[@asrarahmed1629]

Great teaching!
Thanks...

[@beasttrader4530]

bhai sabse badiya enthusiasm tha aaaapka

[@OriginalKhandeshi]

Thanks to explain in simple way

[@chulbulikiduniya94]

very well explaned

[@39_palakved23]

Thanx

[@vishalmaddheshiya3625]

thank u thapa sir fo this series...love you

[@faizanfaith]

Good ho gya Bro , boht easy smjhaya Ap ne , 😍

[@HIMALM24]

Thank you so much vinod

[@PankajYadav-ty8yo]

Thanks for sharing info

[@gauravjha4325]

Thank you Thapa

[@ravindrabaraskar3038]

Good explanation ❤

[@husnainafzal2946]

Great teaching style

[@Vptechvelly]

very good explained the this topic .nice video.

[@hinduculture682]

Ek number sir 🙏🙏🙏🙏🙏

[@_ss809]

Thank You bhaiya🙏👏

[@dhanshrimore5995]

very simple to understand thxx

[@itstechshow7747]

Thanks bhai ❤️‍🩹 watched a lot of videos but exactly i got here ❤

[@sowmyar7402]

Thanks a ton sir!!!

[@sachinmore521]

great teaching sir.

[@mayachaudhary7585]

Bahut easy tarike sikaya

[@alinakhan7480]

you are working good

[@29ibrahimsayed95]

really helpful

[@endlessmiles2574]

Best describe

[@FarhanAli-km5id]

Very helpful and well explained... thanks sir from Pakistan...👍👍👍❤️❤️

[@TheEpicNik_]

Nicely tutored. Concept cleared. Thanks @Thapa Technical.

[@tiwarianjali3049]

Thanks Bhai superb explanation 👍

[@farhanmalilk6126]

solid teaching skill

[@dfordemo981]

great video, thanks

[@rudra97895]

You are a superstar

[@blenderstuffs]

W3school se padha tha kya aapne??

[@kawaljeetsinghchadha7246]

Was able to understand concepts well.. Good video buddy...

[@ManishKumar-gx9no]

Really helpful.. Thanks a lot

[@SohanSinghRawat-w6m]

dai thank voli exam cha aju tapai koh vidoes leh dere help gariyo. thanks dai

[@srinivasaraoyp3640]

Your explanation is fantastic. Badiya Hua. Keep it up.

[@souvikghosh6025]

Thanks vai

[@vishalkhokar6303]

bhai thanks

[@salonithakur7851]

Very nice explanation 😇

[@meghakashyap3504]

thanks for this amazing video

[@Coding_Asmr_PraDev]

Boom vinod bhai awesome video

[@ThapaTechnical]

thanks bro :) plz share kr dena apne dosto ko bhi

[@riyasaxena9445]

Its really a good video

[@ashwinipawar3583]

thank u so much ser your videos are awesome

[@flint4151]

Amazing Bro..Thanks a lot

[@dhavalpatel3455]

Nice video

[@zeetshafiq2933]

Behtreen👍

[@JatinSharma-vg9hu]

Thanku Sir

[@andythomson2227]

Only video on youtube which gives the best and simple explanation.

[@349_rahulbhattacharya6]

BEST !!!!!!!!!!!!

[@vinaysingh2971]

Bahut badhiya Thapa

[@stech3696]

Osm explanation bhaiya jiiii❤️❤️❤️❤️❤️🙏🙏🙏🙏🙏

[@AashishKumar-or9lu]

nice brother . Another brother from nepal

[@laibanasir6293]

Great teaching way sir ❤️

[@devsabuj4818]

main jo chahta hoon two table hai
1. is user 2. is sales.
admin jis user ka id create karega sirf usika hai sales bo admin dekh sakta hai.
display tables like below..
sl,date,user datewise total sale of the user ,calulate commission...
jis date main jitna user sale karega us date mai date ke sathe har user naam aur iski sathe uss date total sale dikhegi..
table nice total sales ayegi & commision ka value ayegi(commision har user ke liye alg alg hai)...
please clear the query matter

[@abhisheknanda7]

Nice concept sir

[@zekrullahdurrani7662]

perfect

[@sahikitalaash6280]

such a good explanation!!

[@sanjaykushwah9420]

Sir make a video on sql stored procedure

[@AtechSeva]

Superb 🔥

[@namanmittal2808]

Wow!!

[@fastprogramming.]

Gajab 👍👍

[@leepakshiyadav1643]

Amazing teaching 😁

[@sushantrahane4512]

Sir please make a video of locking with examples

[@_thakur._.ashu_]

Nice👍

[@dipi411]

Thanks, man you have made SQL joins really easy..Best video on joins

[@rushikeshjadhav8346]

Super

[@ahmadmasood3939]

starts at 01:44
but video is great

[@easystudy6981]

very well explained bhai , maza a gaya is video se padh ke , thank you so much ...............hehehehehe

[@izharkhankhattak]

Very nice, Man!

[@DEEPANSHU_NAG]

Awesome 👏🏻👏🏻

[@snehamhra]

Ye toh sach hai ki Bhagwan hai ...!! You saved my Life !!

[@nishantgautam9298]

😂

[@akhileshtalwaniya8927]

sir aapne right join keyword me left join ki defination show ki h in your video . but the defination of right join is this ''The RIGHT JOIN keyword returns all records from the right table (table2), and the matching records from the left table (table1). The result is 0 records from the left side, if there is no match.''

[@bapitaroy2570]

bhai multivalued attributes ki entry kaise lete hain, example dekhe plz bataoge?

[@Healthcareerperson]

Are you help in personal query issue as well?😊

[@bobbysingh72]

awesome

[@Codeing-di3yf]

♥♥

[@digvijayyamagekar4300]

no doubt the best explanation, thanks man

[@sumitsrivastava6391]

Ultimate teaching skills :)
Thank you