Difference between Equi Join and Non Equi Join in SQL Server | MSSQL Training | By Mr.Sudhakar L

[@NareshIT]

Please Comment, Subscribe and Click Bell🔔🔔🔔 Icon for More Updates. To learn software course from our experts please register here for online training: goo.gl/HIB0wL

[@srinivasreddypallapolu2754]

The way u r explaing is simply super and no need to practice also it will directly loading into brain permanently keep it up Mr.Sudhakar

[@charanteja5533]

Sooper..I became a fan of your class..😊👌👌👌👌👌

[@geethanampalli3134]

hi sir ....first of all your way of teaching and english excellent sir thank you so much

[@hemantbhatt1486]

11:20 it’s equi join or Inner join so it matches total make sense Good example thank you simple to understand

[@abhinavchennabhatni6796]

Thank you Mr sudhakar, the way u explained made sql very easy

[@hanifshaikh5406]

Dear Mr. Sudhakar, Well done and keep it up!! can u share the list of videos you have uploaded for MS SQL in chronicle order. This will be a great help to the learners. Thnx and regards,

[@nilamnavgire2227]

Awesome teaching 😍😍😍😍🙏

[@kalyani_kreations]

Your explanation is very well sir

[@kasthursri1208]

Mr.sudhakar sir well teaching sir you can uplod more videos sir

[@christal9968]

Thank u sir🙏

[@mohansaivelagapudi929]

Thanks for helping sir

[@srikanthchowdary4734]

nice explanation sir ,but need more example to clearly

[@ankush_in_sync5998]

Sir how how that greater than condition is joining? and creating that output please explain

[@nagarani6658]

sir well said this is very helpful to us. but sir inner join and equi join is same, why we are using both ? sir can you please tell t to us.

[@mds6750]

Cool...

[@balajigeriga6295]

We have a join name called inner join. If we apply inner join matching records will come from both tables. Why will go for equal join?

[@hariprasad361]

I have same question in my mind....,

[@hasnatplays7603]

@@hariprasad361 same question can anyone explain

[@hasnatplays7603]

so i found the difference inner join uses ON keyword whereas equi join uses where keyword

[@rajansingla5516]

Sir, In your last two queries , how can we distinguish between the difference of equi and non equi joins ,,,,,my mean is if we place equal operator in your last query then there is no error because in both queries there is no keyword for equi and non equi joins that distinguishes the both queries , based on your last query if we use equal operator then the last query will be run successfully !! Hope you understand my point !!😅😅 Anyways you are amazing sir !! Excellent teaching !! God bless you !! ☺️☺️

[@Anonymous45696]

In equijoin there is equals to after where and in nonequijoin there is everything other than equals to

[@vijayanks1714]

🙋‍♂️

[@sathishkumar-hx3fv]

YOU SAYING SIMPLE WAY LIKE (SOME ONE ASKING YOU HOW TO learning BIKE. YOU SAY FIRST ON THE BIKE KEY, THEN RAISE , THEN FIRST GEAR , THEN GOOOOOOO) SILLY