PostgreSQL: ERROR column reference "id" is ambiguous in a JOIN
@aiden-f-dsouza▲ 8 net votes
Qualify the column with its table name or alias, e.g. select emp.id from emp join dept on emp.dept=dept.name. Unqualified select id from emp join dept on ... where both tables have an id column fails with: ERROR: column reference "id" is ambiguous. The qualified version returned rows 1 and 2. Tested with psql on PostgreSQL 16.14.