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