SQL The column 'Id' was specified multiple times

Question

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'.

Obviously both `3D_Benchmarks` and `3D_Slugs` have the `id` column — zerkms, May 30 '12 at 02:41

score 14 · Accepted Answer · edited Apr 11 '17 at 18:15

14

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

edited Apr 11 '17 at 18:15

answered May 30 '12 at 02:59

Yaqub Ahmad

27,569
23
102
149

5

but I have 20 columns, there must be a simpler way, maybe assigning the columns with the Id with AS – Mario May 30 '12 at 13:30
1

`tablename.*` did it for me. I only needed to select from one table. Thanks! – tedi Oct 04 '17 at 06:20

score 0 · Answer 2 · answered May 30 '12 at 04:02

0

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

3D_Benchmarks have id column,3D_Slugs have id column too.

for explame:[3D_Benchmarks].id as aid,3D_Slugs.id as bid

answered May 30 '12 at 04:02

maco_wang

21
1

SQL The column 'Id' was specified multiple times

2 Answers2

Linked