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 KZbin 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: kzbin.info/www/bejne/g6OQZJx7nr1prsk ➡️ Follow me on Instagram: instagram.com/vinodthapa55/ Must Watch Videos For Web Development. ➡️ HTML in One Video: kzbin.info/www/bejne/pn-ac3mCm7idfNk ➡️ CSS in One video: kzbin.info/www/bejne/npy0p2OEft1-h7s ➡️ JavaScript in One video: kzbin.info/www/bejne/hoCnmIONYs2VnLc ➡️ ECMAScript 6 in One Video : kzbin.info/www/bejne/f5bOZXeqh9SVgqM ➡️ HTML5 in one video: kzbin.info/www/bejne/aoeTXoymhJJ-kNE ➡️ CSS3 in one video: kzbin.info/www/bejne/infVd6ttfZqNf5o ➡️ Bootstrap4 in One video: kzbin.info/www/bejne/r4vRf6GsjbRrfqs ➡️ Jquery in One video: kzbin.info/www/bejne/hn_ZqoN7hpWsY6s ➡️ JSON in one video: kzbin.info/www/bejne/mH7UlqmGgKaDepY ➡️ ReactJS in one video: kzbin.info/www/bejne/amSsk3l6iLuXeJI ➡️ PHP in One Video: kzbin.info/www/bejne/aWGVZX6Za7h3gJI ➡️ NodeJS in one video: kzbin.info/www/bejne/n6HRiHSBpM51qrs ➡️ MySQL in one video: kzbin.info/www/bejne/a5OpqZWtn7Ngfc0 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 KZbin Channel Link: kzbin.info/door/Est... Plz Subscribe with all your friends :) Thank You. click on the link below to watch web developer courses videos HTML in One Video : kzbin.info/www/bejne/pn-ac3mCm7idfNk CSS in One Video: kzbin.info/www/bejne/npy0p2OEft1-h7s Javascript tutorial in one video: kzbin.info/www/bejne/hoCnmIONYs2VnLc PHP in One Video: kzbin.info/www/bejne/aWGVZX6Za7h3gJI DAtabase and PHP Together for read, create, update, delete: kzbin.info/www/bejne/r2bQc3uGqaqCa9k How to create a website like carbon health: kzbin.info/www/bejne/jWOUo6F6o51_b7c How to create a website: kzbin.info/www/bejne/r5e8lJtjfcqljJY 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.

[@willturner3440]

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

[@manasgain]

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

[@icodeideas_]

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

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

[@saurabhverma25]

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

[@Deleted12347]

Thanks bhai, I will share this video with my friends

[@coderbravo1275]

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

[@arnavgupta7392]

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

[@kidzzone441]

🎉🎉🎉

[@monikatanwar4211]

Thanks for short n sweet material🤗🤗

[@hrithikahuja7663]

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

[@easystudy6981]

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

[@shehzadafzal658]

Method of teaching is so good sir

[@beasttrader4530]

bhai sabse badiya enthusiasm tha aaaapka

[@ahmadmasood3939]

starts at 01:44 but video is great

[@meghapengoria77]

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

[@blenderstuffs]

W3school se padha tha kya aapne??

[@Monika_choudharyy]

Superb concept clear in just 20 minutes. Thanks

[@faizanfaith]

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

[@gauravgaurav6055]

Thanks!

[@ravindrabaraskar3038]

Good explanation ❤

[@archanachaudhari7546]

Tnx...Your video helps a lot

[@itstechshow7747]

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

[@OriginalKhandeshi]

Thanks to explain in simple way

[@mayachaudhary7585]

Bahut easy tarike sikaya

[@chulbulikiduniya94]

very well explaned

[@snehamhra]

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

[@nishantgautam9298]

😂

[@AashishKumar-or9lu]

nice brother . Another brother from nepal

[@rishabhyadav1898]

Excellent video. Thank you sir👍👍

[@This__is__akash]

A very elegant explanation ..

[@SMHasan9]

Thanks a lot

[@user-wg7po7ql5d]

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

[@hinduculture682]

Ek number sir 🙏🙏🙏🙏🙏

[@shitalawchar9086]

Thanks sir

[@vishalmaddheshiya3625]

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

[@Vptechvelly]

very good explained the this topic .nice video.

[@asrarahmed1629]

Great teaching! Thanks...

[@kawaljeetsinghchadha7246]

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

[@53_manishkumar_it54]

thank you bro

[@Coding_Asmr_PraDev]

Boom vinod bhai awesome video

[@ThapaTechnical]

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

[@rudra97895]

You are a superstar

[@husnainafzal2946]

Great teaching style

[@FarhanAli-km5id]

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

[@endlessmiles2574]

Best describe

[@srinivasaraoyp3640]

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

[@stech3696]

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

[@bhushanambhore8378]

Thank you sir ji

[@scholar_boy425]

Thankyou sir so much

[@39_palakved23]

Thanx

[@_ss809]

Thank You bhaiya🙏👏

[@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

[@digambar6191]

Thnx sir

[@tiwarianjali3049]

Thanks Bhai superb explanation 👍

[@HIMALM24]

Thank you so much vinod

[@vinaysingh2971]

Bahut badhiya Thapa

[@dhanshrimore5995]

very simple to understand thxx

[@salonithakur7851]

Very nice explanation 😇

[@ManishKumar-gx9no]

Really helpful.. Thanks a lot

[@sachinmore521]

great teaching sir.

[@Gandhiboy]

Thank you so much

[@sowmyar7402]

Thanks a ton sir!!!

[@PankajYadav-ty8yo]

Thanks for sharing info

[@alinakhan7480]

you are working good

[@farhanmalilk6126]

solid teaching skill

[@riyasaxena9445]

Its really a good video

[@gauravjha4325]

Thank you Thapa

[@dhavalpatel3455]

Nice video

[@user-sf6it7cn3k]

video starts from 1:47

[@mayankaggarwal1690]

3:13 inner join ❌ MYSQL inner SQL join ✅

[@TheEpicNik_]

Nicely tutored. Concept cleared. Thanks @Thapa Technical.

[@vishalkhokar6303]

bhai thanks

[@dfordemo981]

great video, thanks

[@flint4151]

Amazing Bro..Thanks a lot

[@zeetshafiq2933]

Behtreen👍

[@29ibrahimsayed95]

really helpful

[@349_rahulbhattacharya6]

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

[@andythomson2227]

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

[@ashwinipawar3583]

thank u so much ser your videos are awesome

[@meghakashyap3504]

thanks for this amazing video

[@muhammadkamranjaved2424]

Thank you

[@leepakshiyadav1643]

Amazing teaching 😁

[@AtechSeva]

Superb 🔥

[@souvikghosh6025]

Thanks vai

[@abhisheknanda7]

Nice concept sir

[@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.''

[@Healthcareerperson]

Are you help in personal query issue as well?😊

[@sitaramrathi7483]

यह तो एक उदाहरण के लिये दिये है इसी तरह से अलग अलग परिवारो के अगर हजारों लिखने हो तो कैसे होगा

[@nishantgautam9298]

If I have a table of customers in which there is a id as primary key and I have an another table name orders in that table there is column customer_id as a foreign key. Now I am joining the both table with this query SELECT*FROM orders JOIN customers ON orders.customer_id = customers.id; why table of joining output is not coming tell me the reason.

[@sahikitalaash6280]

such a good explanation!!

[@nityasingh1423]

Sir i am not able to do outer join , can you please help by showing the syntax with the same example ,it's ok if you show syntax in comments Box

[@sanjaykushwah9420]

Outer join not support in mysql RDBMS

[@jagdishgurram]

SELECT * FROM customer LEFT JOIN orders ON customer.cid = orders.cid UNION SELECT * FROM customer RIGHT JOIN orders ON customer.cid = orders.cid;

[@pradeepbkale]

Badly stuck Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'music_store.customer.first_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by need help

[@maverickkunal5842]

And about full outer join?

[@izharkhankhattak]

Very nice, Man!

[@junaidengineerings]

good concepts.

[@laibanasir6293]

Great teaching way sir ❤️

[@sanjaykushwah9420]

Sir make a video on sql stored procedure

[@ManiKumar-kc1bg]

Right join kam aaya in tables me kyuki agar boss puche ki mughe bus wo costomer record do jinhone order diya he with order amount then we can use right join

[@dipi411]

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