Hi,

1. I have query like this:

CREATE VIEW vTimeMaintenanceList
AS
SELECT FIRST 100 SKIP 0 ATTENDANCE.ADATE,
employee.empid,
employee.name,
ATTENDANCE.STIME,
ATTENDANCE.ETIME,
ATTENDANCE.OUTLUNCH,
ATTENDANCE.INLUNCH,
ATTENDANCE.STATUS,
ATTENDANCE.REASON,
ATTENDANCE.SHIFT,
ATTENDANCE.OVTID,
ATTENDANCE.REMARKS,
employee.comid,
REASON.DESCRIPTION,
employee.Job,
employee.organization,
employee.Branch,
ATTENDANCE.ServerLocation,
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?

2. Is firebird support SELECT CASE? Does anyone have any idea how to convert a
view that are using SELECT CASE to firebird? Can I do it in Firebird or I
have to make it a store procedure instead of view?


Thanks,
-regina-