Select From Multiple tables Comma Separated
join, select, sql-server, t-sql
Solution
I saw this code in some recently Microsoft procedures (ASP.NET Membership). As a bottom line, it is the same if you have INNER JOIN.
Thank you for your responses!
Problem
What is best (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] ``` Thank you! UPDATE Read this article.