MySQL INNER JOIN Tutorial in Hindi / Urdu

In this tutorial you will learn mysql inner join tutorial in Hindi, Urdu.You can learn how to use inner join in mysql and get selected data from two or more tables in hindi.
PHP Tutorial in Hindi Playlist
• ✅ PHP Tutorial in Hind...
MySQL Tutorial in Hindi / Urdu Playlist
• 🥇 MySQL Tutorial for B...
Official Website
www.yahoobaba.net/
Follow us on Facebook
/ yahooobaba
Follow us on Twitter
/ yahooobaba
#mysql #webdevelopment #php

[@shahezadkhan6128]

Sir aap ko jitna thanks kiya Jaye kam hai you are great sir really you are the best teacher ever I am third year student of BBA CA and I am doing my last year project in php such a greaaaat series I got to clear my all dauts and problems because I was in covid batch but now I have various strengths to do best sooooo really really thanks to yahoo baba I am really really thanks to you sir 🙏 🙏 🙏

[@YahooBaba]

Your most welcome :)

[@arvindsinghjugtwan9588]

kafi acha smjhaya sir apne ye topic ....bilkul boring ni lgra...aur puri achi thra smjh aya

[@YahooBaba]

Thanks :)

[@dipeshparma8605]

Thank you so much, bhai..
Till now I have watch so many videos of inner join but I don't understand anything but,you are the best for me becausee of your teaching method and your presentation is batter than others videos and people.
Thank you so much Again Brown 👍

[@YahooBaba]

Glad to hear that

[@Fitnes_Revolution]

The way you teach is amazing sir..👍👍

[@yvayahavv]

Thank you sir, videos contains all the information required to learn mysql and very nicely explained😊

[@YahooBaba]

You're most welcome

[@AniMation_Nation7]

THANK YOU SO MUCH
I AM FROM PAKISTAN
Fantastic. Exactly what I was looking for

[@YahooBaba]

Your most welcome :)

[@syedazahid7839]

Hats off to you sir for such a simple way of teaching. I was doing it last night for about 3 hrs but wasn't able to learn it because the instructor wasn't doing well. Nevertheless, thanks alot.

[@YahooBaba]

It's my pleasure

[@about_555]

jordar bhai explantion

[@JokeAndTalk]

Thankyou sir so helpful for me❤️❤️❤️

[@dibbyo456]

Fantastic. Exactly what I was looking for.

[@YahooBaba]

👍

[@Aaron-ro1ln]

Love this channel

[@sports-lover1396]

Loved the way you explained Sir , thanks for it

[@YahooBaba]

Thanks and welcome

[@Anilkumar-qp8ll]

it supper helpful................. brother

[@IqraMubeen.sheikh]

Thank you so much ❤

[@meghnathjani5956]

6:17 It is interesting to note that alias names *p* and *c* are used in the SELECT command before assigning alias names in the FROM command.

[@dipaksharma455]

SAME THING I HAVE NOTICED

[@DeepakKumar-fq1hw]

So query is correct or incorrect

[@DhavalAhir10]

​
FROM COMMAND execute first and then where... At last SELECT executed

[@saharamanson1970]

NICE VIDEO ...........AWESOME

[@subodhkhobragade3093]

Nice.. conceptual

[@toxicabhi589]

Sir sach main aap bohot acche tarike se matlb kya batau yar aap bohot acche se padhate ho .. actually maine aapke php javascript and css ke saare dekh playlist dekh liye ...fir muze mysql main doubt tha , to socha aapke pass hoga uska bhi playlist and what ..sir u cant believe that .maine ek hi video se saara samjh main aa gya .. salute hain sir ji aapko ❤️❣️💗

[@YahooBaba]

Thanks and welcome :)

[@Sans_K5]

well explained sir💜

[@niteshchaurasiya1531]

Very Nice explanation sir aj jakar samjh me aaya join . you are great sir . your all video are very good.

[@YahooBaba]

Thanks and welcome

[@tanshmay]

You’re god thank you!

[@zaharaameer8723]

GazakiAllah Sir G

[@beingunstoppable.]

Bhhot achaa samjhaya hai keep it up your good work ❤️❤️❤️❤️

[@YahooBaba]

Most Welcome :)

[@user-lm5wb8vi1x]

Finished watching

[@devkaransinghrajput3670]

Nice video sir helping me for job

[@jigyasasoni1812]

Thank you sir.

[@dhruvrajsinhjadeja-vfxarti3085]

Thank you very so much for this video sir :)

[@YahooBaba]

Most welcome!

[@kyawn5115]

Thank you, really helpful content!

[@YahooBaba]

Glad it was helpful!

[@anup4009]

extremely easy to understand,
thank you 😃

[@YahooBaba]

You are welcome!

[@aquibali6798]

Nice explanation sir... Great content and easy way of teaching style....
Thanks sir

[@YahooBaba]

Thanks and welcome

[@darshanpatil5724]

Nice explain✅

[@MdSumon-fq8ro]

Perfect video,,I appreciate your help,

[@YahooBaba]

Glad it helped

[@iamsatyadeep]

Nice explanation as i expect👌👌

[@YahooBaba]

Thanks Satya :)

[@rajneeshraikwar8352]

Thank you

[@MuhammadTalha-lv2ze]

Superb Sir

[@oneplus617]

Sir I really really die hard thank to you for gave such a meaningful Lecture.. your teaching style is great great... जय श्रीराम

[@YahooBaba]

Your welcome ...Jai Shri Ram

[@yashlingayat7374]

nice sir
🙏

[@VIPINKUMAR-kb1ru]

Very nice

[@bhargav8263]

nice explanation in every video of mysql,i have seen many

[@YahooBaba]

Thanks for liking

[@abhishekbhalla3197]

best of best thankyou

[@YahooBaba]

Your welcome :)

[@maksahani2168]

Thanks

[@hareshparab7808]

thanku

[@piyushkumar4919]

thanks

[@mayanksen7476]

Thank you Sir..

[@YahooBaba]

Most welcome

[@deepakpradhan7168]

Thank you so much sir

[@YahooBaba]

Most welcome

[@anmolanesha1350]

Best video ever

[@YahooBaba]

Thanks Anmol :)

[@jamalmehdi2788]

thank u so much sir

[@YahooBaba]

Most welcome

[@amitdandagavhal7730]

really good information

[@YahooBaba]

Glad you liked it

[@bhagirathiverma2627]

thanku sir🙂🙂🙂🙂🙂🙃🙃🙃🙃😊😊😊😊😊😋😋😋😋😋😋😇😇😇😇😇

[@anshulsaini7440]

Happy Teachers Day Sir

[@YahooBaba]

Thanks Anshul :)

[@nixgamerz9485]

❤

[@ramanand6836]

😍😍

[@krtv7032]

thanks sir

[@YahooBaba]

Most welcome

[@aakashsingh8331]

superb sir

[@YahooBaba]

Thanks :)

[@varunjain3756]

Sir, While entering data into personal table, how we'll be able to identify which state has which id? do we need to check manually in such case?

[@YahooBaba]

Varun we uses MySQl with any Programming language like PHP, Python to get the particular data. You can check this video what u r asking for : ruclips.net/video/S8M7V5mdSdI/видео.html

[@varunjain3756]

@@YahooBaba Thank You Sir 😊

[@QasimTanoli-op3zg]

amazing make a video to show three tables data by using a foreign key example: a student that has Id 3 and the class Id 4 means 5th class how to show Id 3 class name in PHP front end ??? hope you will response soon.

[@YahooBaba]

Video is coming soon regarding joining of three tables :)

[@abhishekkumardubey2298]

👍👍👍👍👍👍👍👍👍👍👍👍👌

[@neerajthapak]

Sir i want to ask, rdbms and sql is my exam syllabus inme se kisko pehle study karu air jisse samajh me a jaye, u r best teacher sir anse teacher college me nahi hote.

[@YahooBaba]

Pehle SQL karo tab aapko RDBMS bhi samajh aajayega.

[@neerajthapak]

@@YahooBaba thanks sir for reply

[@sarveshattri3752]

Sir it's compulsory to use joins on the foreign key or primary key

[@YahooBaba]

Yes

[@NoOne-gh2rc]

Plz launch your java course

[@NoOne-gh2rc]

Waiting for more js videos

[@YahooBaba]

coming soon

[@NoOne-gh2rc]

@@YahooBaba are you know JAVA?

[@sonu__irfan]

bhaijan inner join is als working without any primary key and foreign key ,wat u say about it??

[@YahooBaba]

Foreign key toh compulsory nahi hai lekin Primary Key ke bina join nahi ho sakta.

[@karanchhatbar3107]

if we have to define inner join everytime after using foriegn key then can we say that foriegn key is only used for connecting tables nothing more..am i right?? correct me if i am wrong😄

[@YahooBaba]

Yes u r right.

[@neerajthapak]

Sir natural join theta join equi join ke function same hai ya thoda different pls cover kar dijiye

[@YahooBaba]

Yeh sab JOINs MySQL mein nahi hote.

[@shrutinandanwar8549]

explain this foreign key concept where how can i use this foreign key on already existing table

[@YahooBaba]

For that you have to use ALTER command. You can see that ALTER video in this same course playlist and read this article to ad Foreign key to already existing table : stackoverflow.com/questions/10028214/add-foreign-key-to-existing-table

[@angelthedecentgirl7181]

if you have two tables having empid ,name years of experience,
--monthly salary and --other table having attributes id and annual salary, then how can we find the emp who have
--expoerince >7 years and salary >1 lakh

[@YahooBaba]

After INNER JOIN you have to use WHERE CLAUSE and in Where clause use two conditions like table1.experience > 7 AND table2.salary > 100000

[@JiteshKolhe1]

Bro, Laravel aur bootstrap padhna jaruri hai kya fresher ke liye. ..kab padhna chiye use.

[@YahooBaba]

Agar aap Web Designer banana chahte ho tabhi Bootstrap seekhna jaroori hai warna zaroori nahi hai. Agar aap PHP developer banana chahte ho toh Laravel seekh lijiye.

[@JiteshKolhe1]

@@YahooBaba full stack developer banna thik hai ki kya kare sabse pehle. Job ke liye pehle kya padhe.

[@Stenoworks]

i face error 1005 error when apply foreign key plz help

[@hamzahashmi9250]

sir maine personal table main aik or column add krna ha grade ha kese ho sktaa ha?

[@YahooBaba]

Use the ALTER command for that. See the related in video in MySQL course playlist.

[@hritikvibes6492]

Please give us data file for do practice

[@jiazafar24]

I am getting this error when i run your code for personal table. Error Code: 1005. (errno: 150 "Foreign key constraint is incorrectly formed")

[@fahadmaqsood5636]

Check Your database structure cjeck you set in second table

[@rayanali9737]

the column selection commands are working fine without alias:
SELECT
id, name, percentage, age, gender, cityname
FROM
personal p
INNER JOIN
city c ON p.city = c.cid;

[@YahooBaba]

p and c are alias.

[@neeteshthakur506]

Can uh provide the pdf of mysql content
🙏🙏🙏it will be very helpful for me

[@YahooBaba]

You can get it from our website : www.yahoobaba.net

[@hamidansari9331]

Sir pdf bhi provide karaiye

[@hardeepsingh3044]

A or B TABLE me se A ka
only uncomon data kasie fetch hoga??????? WITHOUT FETCHING THEIR COMMON DATA

[@YahooBaba]

Read this Article for that : stackoverflow.com/questions/1096478/how-to-fetch-unmatching-records-from-two-sql-tables

[@uddeshdharmik8168]

Ap bhopal se ho kya?

[@YahooBaba]

No, I am from Ambala (Haryana)

[@uddeshdharmik8168]

@@YahooBaba nice videos🔥👍

[@ShwetaUpadhyaya19]

Why I'm getting only one row instead of getting whole row and column?

[@YahooBaba]

Paste ur SQL command here

[@shwetajaiswal777]

Sir I'm getting error code:3780 foreign key constraints incompatible

[@YahooBaba]

This error comes when Data type of Primary Key column and Foreign Key Column are different.

[@deepanshidhingra]

After doing inner join my city and cid columns are coming in ascending order . Help ?

[@YahooBaba]

Use (ORDER BY) clause to change the order.

[@deepanshidhingra]

@@YahooBaba okay thanks

[@jashanpreet832]

Yupp correct I'm replying same 😊

[@bahadurkhan4918]

Sir I used inner join but data not showing without error.

[@YahooBaba]

I can not tell anything without looking your SQL command and Table Structure. Paste ur SQL command here.

[@praveensuthar6776]

sir mene toh koi foreign key set nai ki fir bhi ye sab perfect work kar raha hai why ??

[@YahooBaba]

Foreign key is not necessary but Primary key is necessary that's why your SQL command is working fine.

[@NoOne-gh2rc]

Sir, Are you know JAVA?

[@YahooBaba]

Yes I know Java

[@saeedahmad6378]

good

[@masterstockgaming3200]

What is different between equal jion vs inner jion ??

[@YahooBaba]

What is jion ?

[@masterstockgaming3200]

@@YahooBaba sorry spelling mistake Equal Join vs inner Join .?

[@iqrakhalid5689]

kindly sir jldi reply kr dey

[@RahulYadav-qg7xi]

sir in my table when city name is repeated then the same name are show together and my id no are not in sequence if id no.1 and id no. 4 are having same city then 1 &4 are came together so sequence is 1,4,2,3,5,and so on plz tell me the right solution.

[@YahooBaba]

SO you have to use "Order By" city column.

[@RahulYadav-qg7xi]

@@YahooBaba sir is there any orther way that i can send you pictures of my data?

[@YahooBaba]

@@RahulYadav-qg7xi For what ?

[@RahulYadav-qg7xi]

To send pictures of data to show you what i want to ask

[@YahooBaba]

@@RahulYadav-qg7xi My email id : [e-mail]

[@MuhammadAwais-kv9bm]

yahi to smj nai ati k aliasing krne se phehle hi usko use kese kr skte hain system ko kese pata chalay k ye alias kis se relted hai baqi thoery tak thek hai

[@technicaltambu5482]

Muje ek parle biskut, ek samosa lakar do deu kaka or samosa bhaiya se
Aapko jis tarah pata chala same system ko bhi ese hi pata chalega
Pahele use kya lana he or baad men kaha se lana he, ese system kaam karegi

[@iqrakhalid5689]

sir kb free hotey hn

[@DeepakGupta-hj2dv]

Kitne video aur rah gye hai

[@YahooBaba]

10 videos rahte hain

[@iUmerFarooq]

@@YahooBaba Sir please *10 Days* nahi lana, *10 tutorial* k liya, *max* 4 to 5 Days ma finish karan Please?

[@hussainkeshwani6968]

how to zoom in sql workbench

[@YahooBaba]

zoom ?

[@hussainkeshwani6968]

@@YahooBaba zoom in the size of screen

[@iUmerFarooq]

1. Ya zaroori ha k hum sirf *Foreign key column* ko *Primary Key column* sa match karinga?
2. Hum 2 tables sa ziyada ka kis taran *Inner join* karinga?
3. Ap na *Aliases* karta wqt *AS* q nahi likha, os k bhagair be kam kar raha ha?

[@YahooBaba]

1) Nahi ye zaroori nahi hai Foreign key banana. Aap Primary key ko doosre table ke kisi bhi coloumn se match kar sakte ho.
2) 2 se ziyada tables ko join karne ka tarika mein aage aane wale videos mein bataunga.
3) Alias ka use bina AS ke bhi kar sakte ho.

[@iUmerFarooq]

@@YahooBaba 1. Mtlb ek *Primary key* ka hona zaroori ha?

[@YahooBaba]

Yes Primary Key is important because that's a unique identity.

[@iUmerFarooq]

@@YahooBaba Thank you Sir,
Abhe koe class ana wali ha?

[@raomuhammadsharjeel8029]

Alies nhi aa li us

[@iqrakhalid5689]

sir merey ps time bht thora ha

[@YahooBaba]

Hanji bataiye aapka kya Question hai ? My email id : [e-mail]

[@anshubacchal]

आप table में data बहुत ज्यादा डालते हो तो उससे समझने में परेशानी होती है. डेटा थोडा कम लिजिया कररिये 😊😊

[@wasyul6333]

Kuch samaj nahi aya ye wali video me

[@lahoriyeg9915]

Mat dekho

[@PristineAnimation]

Thanks

[@parth7450]

Very nice

[@muazanqureshi403]

Thanks Dear Sir

[@YahooBaba]

Most welcome

[@softhostit-bhisab-amarhisa7294]

thanks

[@YahooBaba]

Welcome

[@softhostit-bhisab-amarhisa7294]

@@YahooBaba I flow your video every time, nice video best of luck bro.

[@Gaurav87998]

Thanks

[@YahooBaba]

Welcome