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.
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!
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With