Subject Re: [firebird-support] Cannot order By
Author Helen Borrie
At 07:06 PM 8/07/2003 +0700, you wrote:
>That doesn't work either,
>Is it because I use the "Outer Join" Syntax ?

No - you can order by a column that contains nulls.
You seem to be getting the wrong error for a query that is sorting on a
date column (or is it NOT a date column?)

All things being equal, because you created the view with double-quoted
identifiers, this statement should get what you want:

Select * from "QSALDORAW" order by "DATE";

If not, I don't know what's causing the problem.

>Is there any other way to make my DATA ordered without that syntax (order
>by) ?


from "QSALDORAW" order by 5;