Most Frequently asked SQL JOINS Interview Question | What does different SQL JOINS return

[@CodingGlitz]

Thanks for watching. If you want to connect on LinkedIn and stay updated with my professional updates and network with me, here's my LinkedIn profile:
LinkedIn: www.linkedin.com/in/biplabparida

[@sitampatel9047]

Best explanation Sir , Thank you

[@sakshichouhan7417]

Best explanation of joins. This was the most challenging topic for me, the way you explained,cleared all my queries. Thankyou.

[@ChitraPatil-l7j]

Awesome sir... thank you so much sir...now my concepts are clear...its so easy....Thanks again

[@ManormaPandey-q9s]

I always prefer this video, sir explained very well.

[@saikumarsrimurthi1750]

It's total clear..... Nice explanation😊😊

[@rajkasbe53]

the way you talk...... I'm big fan of you
thank you so much for everything u r doing

[@CodingGlitz]

Thanks 🙏

[@mandarganpule]

👏 You explained this complex sql problem with nice example and in very simple language 👍

[@CodingGlitz]

👍

[@Hindavi_8500]

this is awesome i face this q and i m wrong bt now i m very clear thank u so muchb😊

[@rameshchunchu686]

It is Awesome. The way you explained is awesome and very clear and understood the joins more clear

[@CodingGlitz]

🙂 Good to know.

[@veerachowdarykamani8615]

Wonderful content

[@CodingGlitz]

👍

[@namangarg7023]

Though I watched somany other explanation this one best

[@CodingGlitz]

Thanks 🙏

[@KunalKumarSingh-wr1kg]

Excellent 👌👍

[@Nalini08888]

Useful Video

[@vikassinghjayara510]

Awesome video 😍

[@CodingGlitz]

Thanks 🙏

[@mohiuddinansari9356]

Well explained ! thanks

[@mudunuriprashanthi1428]

awesome. sir..clear explanation

[@CodingGlitz]

Thanks 😃

[@JamesBond-ge4mf]

Super 👍

[@MVinodKumar-tt1tu]

Very Nice Video sir

[@CodingGlitz]

Thanks 🙏

[@NishantSinha-c4h]

Impressive video, thanks a lot

[@CodingGlitz]

Thanks 👍

[@travelkare]

Dhnywad sahab 👏

[@CodingGlitz]

😊

[@AbhishekKumar-xd3qq]

superb

[@CodingGlitz]

Thanks 🤗

[@sushantamohapatra1124]

Nice

[@ravi_pandey2815]

❤Bro thank you so much.

[@mellowftw]

brilliant

[@CodingGlitz]

Thanks 😊

[@priyankasaini7204]

thanks

[@ShivamTiwari-hu6hg]

Thank you so much sir :)

[@madhukadam5816]

Sir it's really very helpfull, but please you have to define one join, is Cartesian join

[@CodingGlitz]

Ok sure

[@ashishkumarnaik4255]

when you are doing left using null , why do 2 null records are not coming? timestamp 9:24

[@anujsinghkushwah2712]

easiest explanation of very confusing concept.

[@ankitatarale7914]

Sir please make a video on equi,non-equi,natural and self join also...

[@CodingGlitz]

Sure...

[@hemanthchanti1124]

How many records , we will get as output for full outer join ? Please some one answer....as per thumbnail query

[@dishabirje4679]

12?

[@abhinavkumar2662]

12 as per thumbnail

[@AnshikaSharma-yj4xw]

12.o/p : 10 10 10 10 10 10 20 30 40 NULL NULL NULL

[@travelkare]

Queries used please in GitHub repository?

[@Raja-d6w]

Thumbnail query answers-
Inner join -6
Left and right - 9
Full - 12

[@travelwithmayur527]

Pls upload the multiple join table

[@CodingGlitz]

Sure will try by next week.

[@CodingGlitz]

Join Multiple Tables: ua-cam.com/video/eGdtpdow0rg/v-deo.html

[@meghajoshi860]

Sir if there is 0 instead of null.. will get the same output?

[@CodingGlitz]

No

[@raviyadav-dt1tb]

I think null never considered.

[@kalyanideshbhratar8569]

Cross join me kitne record ayenge

[@CodingGlitz]

M * N

[@ashisrout383]

Same question i faced.unfortunately I could not answer.😿

[@CodingGlitz]

All the best for the future. Keep learning. 🙂

[@ashisrout383]

@@CodingGlitz Thank you very much ,you explained so well.

[@CodingGlitz]

Thanks 😊

[@devashishghosh7497]

Null is just a garbage value one null is not equal to another null

[@ektabagde2880]

output 2 colums me kyu ata hai or konsa assume krna hai?

[@CodingGlitz]

ua-cam.com/video/isQ8up-zUPY/v-deo.html
Please watch this I hope you will understand JOINS completely.

[@ektabagde2880]

@@CodingGlitz Thanks got the concept now

[@devashishghosh7497]

Null is just. Garbage value

[@utsavsagar6665]

Bro you are going very fast not able to understand anything.

[@CodingGlitz]

Please go through this (ua-cam.com/video/isQ8up-zUPY/v-deo.html). complete join tutorial before watching this video

[@mango-strawberry]

thanks