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 .
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!