Re: create view & order by clause

From: Jomarlen <jomarlen_at_aol.com>
Date: 1998/01/31
Message-ID: <19980131002300.TAA17935_at_ladder03.news.aol.com>#1/1

>create view itin_view
>as
> select flight_id
> from avail
> where flight_id in
> (select flight_id
> from itin)
> order by flight_date;

Order by is not allowed in create view.
You have to do the order by when
you select from the view, so you'll need to add flight_date to your query.

John

---

John C. Lennon
Utility Partners Inc.
4300 West Tropicana Blvd LVO-UPL
Las Vegas NV 89103

FOR UTILITY PARTNERS EMPLOYMENT
OPPORTUNITIES VISIT www.utilpart.com

e-mail: jomarlen_at_aol.com
Web Site: http://members.aol.com/jomarlen/

The views expressed in this message
are those of the author and not
necessarily those of U.P. Inc.
and/or its employees.

---

Received on Sat Jan 31 1998 - 00:00:00 CET