Joins

r_ganesh76 · February 9th, 2005, 04:15 AM

Hi Experts,

Can anyone tell me the difference between these two queries. How SQL server handles such queries and the perfomance issues.

Select *
From Table1
      Inner Join Table2
            On Table1.Key = Table2.Key
            And Table2.Key2 = Somevalue
Where Table1.Key2 = someothervalue

And

Select *
From Table1
      Inner Join Table2
            On Table1.Key = Table2.Key
Where Table1.Key2 = someothervalue
And Table2.Key2 = Somevalue

Regards
Ganesh

alyeng2000 · February 9th, 2005, 05:15 PM

No Difference else if you do left join

Ahmed Ali
Software Developer

r_ganesh76 · February 10th, 2005, 12:21 AM

Will there be any performance issue in case of Inner Join??

Regards
Ganesh