Thread: Joins
View Single Post
  #1 (permalink)  
Old February 9th, 2005, 04:15 AM
r_ganesh76 r_ganesh76 is offline
Friend of Wrox
 
Join Date: Jun 2004
Location: Chennai, Tamil Nadu, India.
Posts: 449
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via MSN to r_ganesh76
Default Joins

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
__________________
Regards
Ganesh
http://ganeshprof.blogspot.com
Find your solution here...
Reply With Quote