title: Select From Multiple tables Comma Separated
body: <p>What is best (low resources and speed)?</p>
  <pre><code>SELECT     C.[col1]
             , D.[col2] 
      FROM   tbl1 C,
             tbl2 D 
      WHERE  C.[colid] = D.[colid]
  </code></pre>
  <p>OR</p>
  <pre><code>SELECT  [tbl1].[col1], [tbl2].[col2]    
  FROM    [tbl1] INNER JOIN [tbl2] ON
          [tbl1].[colid] = [tbl2].[colid]
  </code></pre>
  <p>Thank you!</p>
  <p>UPDATE</p>
  <p>Read <a href="https://sqlblog.org/2009/10/08/bad-habits-to-kick-using-old-style-joins" rel="nofollow noreferrer">this article</a>.</p>