.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Kaviya Balasubramanian
Imran Ghani
Post New Web Links

T-SQL

Posted By:      Posted Date: September 28, 2010    Points: 0   Category :Sql Server
 

Which one from the two queries below if efficient? Please advise, thanks in advance.

SELECT TABLE1.* FROM
TABLE1 INNER JOIN TABLE2 ON TABL1.COLUMN1 = TABLE2.COLUMN1
WHERE TABLE2.COLUMN2 = 'XYZ'

SELECT * FROM
TABLE1 WHERE COLUMN1 IN (SELECT COLUMN1 FROM TABLE WHERE COLUMN2 = 'XYZ')




View Complete Post


More Related Resource Links

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend