SQL列“ID”被指定多次[复制](SQL The column 'Id' was

可能重复：
SQL 2005 -被指定的列多次

  SELECT TOP(20) * 
    FROM (SELECT * 
            FROM [3D_Benchmarks] 
            JOIN [3D_Slugs] ON [3D_Benchmarks].Id = [3D_Slugs].BenchmarkId) AS tb 
ORDER BY tb.FPS DESC;

我得到这个错误：

列“ID”被指定多次关于“TB”。

Answer 1:

相反的select *使用select table.columnname或tablename.* 。

Answer 2:

SELECT * 
            FROM [3D_Benchmarks] 
            JOIN [3D_Slugs] ON [3D_Benchmarks].Id = [3D_Slugs].BenchmarkId) AS tb

3D_Benchmarks有id列，3D_Slugs有id列了。

对于explame：[3D_Benchmarks] .ID为辅助，3D_Slugs.id作为投标

文章来源: SQL The column 'Id' was specified multiple times [duplicate]