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);