问题描述
可能的重复:
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;
我收到此错误:
为tb"多次指定了Id"列.
The column 'Id' was specified multiple times for 'tb'.
推荐答案
代替 select * 使用 select table.columnname 或 tablename.*>.
Instead of select * use select table.columnname or tablename.*.