p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   SQL Server 2000 (http://p2p.wrox.com/forumdisplay.php?f=20)
-   -   Joins (http://p2p.wrox.com/showthread.php?t=25303)

r_ganesh76 February 9th, 2005 04:15 AM

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

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


All times are GMT -4. The time now is 07:32 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.