5 Replies Latest reply: Apr 29, 2014 10:49 PM by scott.wesley RSS

    UNABLE TO CREATE A REPORT PAGE WITH A QUERY

    goodluck247

      Hello everybody,

      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?


      Thanx!