Still doesn't work, the error said like below (classical error)

Dynamic SQL Error
SQL error code = -104
Invalid command
invalid ORDER BY clause
Statement: select * from qSaldoRaw
order by 6

----- Original Message -----
From: "Alan McDonald" <alan@...>
To: <firebird-support@yahoogroups.com>
Sent: Tuesday, July 08, 2003 7:14 PM
Subject: RE: [firebird-support] Cannot order By


> try order by 6
> or fully quality the "DATE"
> as
> order by A.TglTerima
>
> > -----Original Message-----
> > From: Yosi [mailto:ysundawa@...]
> > Sent: Tuesday, 8 July 2003 10:06 PM
> > To: firebird-support@yahoogroups.com
> > Subject: Re: [firebird-support] Cannot order By
> >
> >
> > That doesn't work either,
> > Is it because I use the "Outer Join" Syntax ?
> > Is there any other way to make my DATA ordered without that syntax
(order
> > by) ?
> >