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

Question

Amira Bedhiafi · Answer

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.

Satya Karki · Answer

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.

Jignesh Kumar · Answer

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

Rajanikant Hawaldar · Answer

Always specify the table name AND the column name

Hiesh Kidecha · Answer

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.

Salman Beg · Answer

Could you please explain a little bit more. Thanks

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

Answers (6)