--- Regina Phandu <regina@...> wrote:

> Hi,
>
> 1. I have query like this:
>
> CREATE VIEW vTimeMaintenanceList
> AS
> SELECT FIRST 100 SKIP 0 ATTENDANCE.ADATE,
> employee.empid,

...

> ATTENDANCE.DateModified
> FROM ATTENDANCE LEFT OUTER JOIN employee ON
> ATTENDANCE.EMPID = employee.empid
> LEFT OUTER JOIN REASON ON ATTENDANCE.REASON =
> REASON.TREASON
> ORDER BY ATTENDANCE.ADATE;
>
> Is there something wrong with the above query??
> cause, I have error on
> "ORDER". Can anybody help?
>

You cannot use ORDER BY in the definition of a view.
If you want the data to be ordered, user ORDER BY when
you select data from the view.

Gerrit Stegehuis

__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com