CODEWITHSUNDEEP
sql-servert-sqlselectjoin
Nițu Alexandru
Nițu Alexandru

Reputation: 714

Select From Multiple tables Comma Separated

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.

Upvotes: 10

Views: 7087

Answers (1)

Nițu Alexandru
Nițu Alexandru

Reputation: 714

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!

Upvotes: 5

Related Questions