This content has been marked as final. Show 5 replies
I have this query with a self-join:
select flight_id, f.pilot_id, last_name, f.pla_id, pla_desc, city_dep, d.city_name, city_arr, a.city_name, dep_time, arr_time
from flight f, pilot p, plane pl, city d, city a
where f.pilot_id = p.pilot_id
and f.pla_id = pl.pla_id
and city_dep = d.city_id
and city_arr = a.city_id
order by flight_id;
I have created a classic report based on a table first, then I am trying to change the SQL query to the one above and I am getting this error:
Error saving column settings.
ORA-20001: Your query contains duplicate alias names, queries used for reports require unique alias names.
What am I doing wrong? How can I build a report with a form based on a query like this one?