Ambiguous Column 'Site_name'

Question

I have inner join two tables and display. I tried the given below code. But it generate on error "Ambiguous Column site_name' "

SELECT site_name, Mains_Run_Hrs, DG_Run_Auto_Mode, Battery_Run_Hrs,Solar_Run_hrs 
FROM tbl_runtime_report INNER JOIN tbl_site_details 
ON tbl_runtime_report.Site_ID=tbl_site_details.site_id 
WHEREsite_name=@site_name

use alias name in the columns or tablename.columnname – arunbabu Sep 29 '14 at 09:06 — arunbabu, Sep 29 '14 at 09:06
@arunbabu you can't use column alias in a `WHERE` clause. – James Sep 29 '14 at 09:11 — James, Sep 29 '14 at 09:11

score 1 · Accepted Answer · answered Sep 29 '14 at 09:07

If site_name resides in both tables, you need to specify which version you are querying i.e.

WHERE tbl_runtime_report.site_name = @site_name

Alternatively, you could use an alias

SELECT rt.site_name, ... 
FROM tbl_runtime_report rt ...
WHERE rt.site_name = @site_name

score 1 · Answer 2 · edited May 23 '17 at 10:33

1

SELECT  Report.ColumnName,Details.ColumnName
FROM tbl_runtime_report Report
     INNER JOIN tbl_site_details  Details ON Report.Site_ID=Details .site_id 
WHERE Report.site_name=@site_name -- use the relevant alias here

See When to use SQL Table Alias

edited May 23 '17 at 10:33

Community

1
1

answered Sep 29 '14 at 09:08

huMpty duMpty

14,346
14
60
99

Ambiguous Column 'Site_name'

2 Answers2