MySQL INNER JOIN Tutorial in Hindi / Urdu

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

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

[@AniMation_Nation7]

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

[@YahooBaba]

Your most welcome :)

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

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

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

[@dibbyo456]

Fantastic. Exactly what I was looking for.

[@YahooBaba]

👍

[@beingunstoppable.]

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

[@YahooBaba]

Most Welcome :)

[@100rub100]

Your explanation is very well! I appreciate your work, but try to provide some more details in depth if possible.

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

[@Prajju_18]

Super sir ❤😊

[@sports-lover1396]

Loved the way you explained Sir , thanks for it

[@YahooBaba]

Thanks and welcome

[@Aaron-ro1ln]

Love this channel

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

[@Anilkumar-qp8ll]

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

[@bhargav8263]

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

[@YahooBaba]

Thanks for liking

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

[@JokeAndTalk]

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

[@bollywoodmusic125-i3t]

jordar bhai explantion

[@MdSumon-fq8ro]

Perfect video,,I appreciate your help,

[@YahooBaba]

Glad it helped

[@zaharaameer8723]

GazakiAllah Sir G

[@darshanpatil5724]

Nice explain✅

[@subodhkhobragade3093]

Nice.. conceptual

[@iamsatyadeep]

Nice explanation as i expect👌👌

[@YahooBaba]

Thanks Satya :)

[@saharamanson1970]

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

[@devkaransinghrajput3670]

Nice video sir helping me for job

[@abhishekbhalla3197]

best of best thankyou

[@YahooBaba]

Your welcome :)

[@Sans_K5]

well explained sir💜

[@anshulsaini7440]

Happy Teachers Day Sir

[@YahooBaba]

Thanks Anshul :)

[@kyawn5115]

Thank you, really helpful content!

[@YahooBaba]

Glad it was helpful!

[@tansmay23]

You’re god thank you!

[@muazanqureshi403]

Thanks Dear Sir

[@YahooBaba]

Most welcome

[@bhagirathiverma2627]

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

[@MuhammadTalha-lv2ze]

Superb Sir

[@divyadubey6679]

Thank u for this video.. Aapne python ke b video bnaye ho to link share kar de

[@YahooBaba]

Nahi abhi Python ka koi tutorial nahi banaya hai.

[@SandipanSarkar-c8v]

Finished watching

[@yashlingayat7374]

nice sir 🙏

[@amitdandagavhal7730]

really good information

[@YahooBaba]

Glad you liked it

[@dhruvrajsinhjadeja-vfxarti3085]

Thank you very so much for this video sir :)

[@YahooBaba]

Most welcome!

[@anmolanesha1350]

Best video ever

[@YahooBaba]

Thanks Anmol :)

[@mayanksen7476]

Thank you Sir..

[@YahooBaba]

Most welcome

[@parth7450]

Very nice

[@rajneeshraikwar8352]

Thank you

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

[@hareshparab7808]

thanku

[@aakashsingh8331]

superb sir

[@YahooBaba]

Thanks :)

[@jamalmehdi2788]

thank u so much sir

[@YahooBaba]

Most welcome

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

[@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 : kzbin.info/www/bejne/iWmwaIlrosmGmqs

[@varunjain3756]

@@YahooBaba Thank You Sir 😊

[@mohammadsaddam649]

Self join and full outer join is missing 😢

[@sarveshattri3752]

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

[@YahooBaba]

Yes

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

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

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

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

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

[@krtv7032]

thanks sir

[@YahooBaba]

Most welcome

[@PristineAnimation]

Thanks

[@shamastanoli8824]

Sielf join full outer join is missing and sir kindly update this paylist name topic like relations one to many etc triggers store procedure type of keys candidate super key savepoint denormalization why and when we need normalization and few more topic is pending

[@YahooBaba]

Yes, I will cover Self Join, Full Outer Join, Relationships, Triggers, Stored Procedures, Types of Keys, etc. in upcoming videos.

[@shamastanoli8824]

@YahooBaba thankiu but sir when you will upload these topics videos???

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

[@Stenoworks]

i face error 1005 error when apply foreign key plz help

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

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

[@NoOne-gh2rc]

Waiting for more js videos

[@YahooBaba]

coming soon

[@NoOne-gh2rc]

@@YahooBaba are you know JAVA?

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

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

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

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

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

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

[@cloudwings786]

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.

[@abhishekkumardubey2298]

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

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

[@shweta-singh012]

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

[@YahooBaba]

Paste ur SQL command here

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

[@nixgamerz9485]

❤

[@uddeshdharmik8168]

Ap bhopal se ho kya?

[@YahooBaba]

No, I am from Ambala (Haryana)

[@uddeshdharmik8168]

@@YahooBaba nice videos🔥👍

[@NoOne-gh2rc]

Plz launch your java course

[@masterstockgaming3200]

What is different between equal jion vs inner jion ??

[@YahooBaba]

What is jion ?

[@masterstockgaming3200]

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

[@hritikvibes6492]

Please give us data file for do practice

[@ramanand6836]

😍😍

[@NoOne-gh2rc]

Sir, Are you know JAVA?

[@YahooBaba]

Yes I know Java

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

[@abhikevlogs8252]

Kch bhi samjh nhi aaya na primary na forgien key na inner join kyn krte hai aisa 😢

[@YahooBaba]

Inner Join isliye karte hai taki tables light weight rahe aur complex na ho.

[@hamidansari9331]

Sir pdf bhi provide karaiye

[@hussainkeshwani6968]

how to zoom in sql workbench

[@YahooBaba]

zoom ?

[@hussainkeshwani6968]

@@YahooBaba zoom in the size of screen

[@iqrakhalid5689]

sir kb free hotey hn

[@saeedahmad6378]

good

[@iqrakhalid5689]

sir merey ps time bht thora ha

[@YahooBaba]

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

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

[@raomuhammadsharjeel8029]

Alies nhi aa li us

[@anshubacchal]

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

[@iqrakhalid5689]

kindly sir jldi reply kr dey

[@wasyul6333]

Kuch samaj nahi aya ye wali video me

[@lahoriyeg9915]

Mat dekho

[@VIPINKUMAR-kb1ru]

Very nice