Select From Multiple tables Comma Separated

2018-06-25 07:38:40

What is best (low resources and speed)?

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

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

Thank you!

UPDATE

Read this article.

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!

链接地址: http://www.djcxy.com/p/70884.html