Select from several tables Comma

Which is better (low resources and speed)?

SELECT C.[col1] , D.[col2] FROM tbl1 C, tbl2 D WHERE C.[colid] = D.[colid] 

OR

 SELECT [tbl1].[col1], [tbl2].[col2] FROM [tbl1] INNER JOIN [tbl2] ON [tbl1].[colid] = [tbl2].[colid] 

Thanks!

UPDATE

Read this article .

+7
source share
1 answer

I saw this code in some recent Microsoft procedures (ASP.NET Membership) The bottom line is the same if you have an INNER JOIN.

Thank you for your responses!

+4
source

All Articles