SQL tutorial 24 :SQLJoins- Natural Join With ON and USING clause By Manish/Rebellionrider

[@rekhapillai6505]

Good work and well explained.Just a request - can you upload more videos as soon as possible.

[@arshadpervez1031]

Very nice. thanks sir
May you live long

[@santhoshrohit04]

HI BRO, I THINK THE NATURAL JOIN DOES NOT HAVE ON CLAUSE. IF WE JUST GIVE JOIN WITHOUT MENTIONING WHAT JOIN, BY DEFAULT IT WORKS AS INNER JOIN. PLS TELL ME IF I'M WRONG. THANK YOU BRO!

[@vamshisamineniz5905]

really love u r blogs

[@sachink.gorade8209]

Is there any limit on number of columns we can use for Natural join? I mean can we use natural join if there are more than 2 common columns in tables.

[@ayoubanbara2021]

great content

[@gouthamansaravanan7692]

thanks a lot really useful

[@Rebellionrider]

Always a pleasure. Glad you found it helpful ☺️

[@hrithikrudra4292]

Can anyone tell me how the query result of using clause and natural join differs?

[@mohawberel]

U ARE BEST!

[@ronaknmodi]

if there are two tables then easily create natural join by this query
SELECT ENAME,LOC FROM EMP,DEPT;

[@sumanthvarada]

Awesome sir

[@MAnsar-gr2uh]

Bro I have a Question?
Please tell me a defination of target and source table?
How to distinguish between these two terminiolgies?

[@veritasgaurav]

Sr, what is the difference between inner join and natural join?

[@sachinshah391]

can someone explain it to me what is difference between all these queries

[@grovestreet9165]

i can't think anyone can explain better then this this

[@zxmasha]

Thank you so much ..

[@rajeev5999]

Thank you sir.

[@errico3]

hi. thanks. where can i download your sql file to practice it on sql dev? thx!

[@ayazsheikh2574]

difference between ON clause and USING clause

[@ahsanulhaque4075]

please early early submit tut........ Thanks Bhai

[@yogeshagrawal5534]

Natural Join and Using Clause are mutually exclusive. Can anyone explain me this with an example.