create view & order by clause

  select flight_id
  from avail
  where flight_id in
(select flight_id

     from itin)
[Quoted]   order by flight_date;

works fine.

But when I add the following code...

create view itin_view
as
  select flight_id
  from avail
  where flight_id in
(select flight_id

     from itin)
  order by flight_date;

...I get the following error:

  order by flight_date
  *
ERROR at line 8:
ORA-00907: missing right parenthesis

Can anyone see what I'm doing wrong?

Many thanks in advance.

Dipen

PS Thank you to all the people that have helped me in my previous queries! Received on Fri Jan 30 1998 - 00:00:00 CET