Good morning, I am performing a query in postgress and it throws an error:
"ERROR: reference to column «request_num» is ambiguous LINE 4: WHERE request_num in (3,6,9);",
select * from area
inner join empleado on area.num_solicitud = empleado.num_solicitud
inner join bien on area.num_solicitud = bien.num_solicitud
WHERE num_solicitud in (3,6,9);
What is happening to you is that this field has the same name in two or more tables of the query. You have to specify which table the request_num field is from.
Furthermore, I would advise you to add an alias to your tables, to make it easier to reference them.
All the best.