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'.
Instead of select * use select table.columnname or tablename.*.
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