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) ?

Yes.

SELECT "RIN",
"IN",
"OUT",
"BALANCE",
"DATE",
"UOM",
"PRICE",
"NOTE",
"WAREHOUSECODE",
"WAREHOUSENAME",
"ITEMNAME"
from "QSALDORAW" order by 5;

heLen