Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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.

like image 336
Nițu Alexandru Avatar asked Apr 09 '13 10:04

Nițu Alexandru


1 Answers

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!

like image 79
Nițu Alexandru Avatar answered Sep 30 '22 06:09

Nițu Alexandru