什么是最好的(资源和速度低)？
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]
谢谢！
UPDATE
阅读this article.
