Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQL The column 'Id' was specified multiple times [duplicate]

Possible Duplicate:
sql 2005 - The column was specified multiple times

  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;

I Get This Error:

The column 'Id' was specified multiple times for 'tb'.

like image 303
Mario Avatar asked May 30 '12 02:05

Mario


1 Answers

Instead of select * use select table.columnname or tablename.*.

like image 151
Yaqub Ahmad Avatar answered Nov 08 '22 05:11

Yaqub Ahmad