>>CREATE VIEW "QSALDORAW" (
>> "RIN",
>> "IN",
>> "OUT",
>> "BALANCE",
>> "DATE",
>> "UOM",
>> "PRICE",
>> "NOTE",
>> "WAREHOUSECODE",
>> "WAREHOUSENAME",
>> "ITEMNAME"
>>) AS
> Try
>
> order by "DATE"

I dropped the 'reserved words' when I had a chance, so DATE
became ORD_DATE or whatever. Then I don't have to worry
about the ""'s ;)

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services