Column reference "id" is ambiguous, any solution for this?

Nikhy

5y1.4kDatabases & DBA

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Satya Karki5y ago
Hi, It seems like you are joining tables. id ambiguous means you have id column in multiple table and you have not specified id of which table in your statement. So please provide table name and column name in your statement and use alias as @Jignesh suggested.
+2
Jignesh Kumar5y ago
Hi Nikhil,

When you use join and two table have same column name that time this kind of situation comes, Please use tablename.columnName
select T1.id, T1.name from Table1 T1
inner join Table2 T2 on T1.id = T2.id
if you are using postgres as database then follow this link,
https://stackoverflow.com/questions/9821121/postgresql-column-reference-id-is-ambiguous
+2
Rajanikant Hawaldar5y ago
Always specify the table name AND the column name
+2
Amira Bedhiafi5y ago
If you are using SQL, you need to understand that SQL is based on set theory - math & logic.
A set must include unique, non ordered and not the same types elements.
You are facing this error when you retrieve data from more than one tables by joining tables and at least one of the selected columns (it will also happen when use * to select all columns) exist with same name in more than one tables (our selected/joined tables). In that case we must have to specify from which table we are selecting out column.
How to solve it ?
Use aliases.
+3
Hiesh Kidecha5y ago
Ambiguous column references are due to there being more than one column available of the same name. It would be great if you can share your code where this issue occures.
+2
Salman Beg5y ago
Could you please explain a little bit more. Thanks
+2