SQL - Part 59 - Joins (Inner Join, Left Join, Right Join, Full Join and Self Join)

[@ELSafintoTV]

You made my SQL studies so interesting. You are best at what you teach. Thank you

[@harishreeln4706]

tqsm for the patience level which u have been reached ...tqsm helping a lot

[@QAFox]

My pleasure 😊

[@Retro_and_Kalyani]

You are superb now I m loving sql

[@QAFox]

Thank you so much 🙂

[@sravaniDeshireddy]

Thank you so much Arun garu.... for your wonderful explanation along with your patience....🙂🤩

[@QAFox]

For any doubts, live training updates, internship program and free Courses, please join our Telegram channel t.me/qafoxoriginal

[@satishchodisetti2297]

Very Well Explained Arun Garu

[@QAFox]

Thank you :) Note: Join our telegram group here - t.me/qafoxoriginal

[@shivangairan5119]

it would help if you had also considered null values in the tables, also you have not considered duplicate values in the common column

[@MBstudio736]

can u teach joins and some other queries in w3 schools?...plzzzzzz humble request

[@lalahuseyn617]

hi Arun, I get the full table on the self join command. I checked both in Oracle and SQL, can you give me the direction where I made a mistake?

[@SaiRamMohantv]

Another good one Arun, excellent on joins, QA will full join qafox :)

[@QAFox]

Thank you Sai :)

[@VloggySaurav]

Wow lovely explaination

[@kiranharijan2809]

Sir only common column is required or both common column with common data types?

[@HG-xz7jy]

Common column in the sense both values and datatype

[@tanniraju3211]

Thank you so much sir ❤❤❤

[@QAFox]

Welcome :)

[@thrinath7284]

what is use of set operations bcoz we having joins i mean wt is the difference between sets and joins

[@sanketpawar7534]

join combine columns from separate tables; whereas, set operations combine rows from separate tables.

[@sandeepdixit2641]

is this the complete course from beginner to advanced?

[@QAFox]

Yes

[@badsanta7356]

What about Cartesian join?

[@shreyasgowda6439]

For fulljoint Use left join union right join Thank me later😇

[@shreyasgowda6439]

And really thanks Arun sir, for making this tutorial look so easy💕

[@praveenbabria1495]

cross join?? is it the same as full join or not?

[@badsanta7356]

No it's not