but the subselect needs to be a singleton anyway doesn't it? what's the use
of an order by clause?
Alan

> -----Original Message-----
> From: Dmitry Yemanov [mailto:dimitr@...]
> Sent: Saturday, 24 May 2003 7:04 PM
> To: ib-support@yahoogroups.com
> Subject: RE: [ib-support] Order By within Subselect?
>
>
> Joe,
>
> > > > select prodprice,proddesc,(select first 1 fifocost from
> > fifocosts B where
> > > > B.fifobarcode = A.prodbarcode order by fifodate)
> > > > from products A
> > > > where PRODBARCODE = '000103'
> > >
> > >try "order by 1" instead of "order by fifodate"
> >
> > Nope. I get the same error. Besides, I don't want to order by
> > fifocost. I want to order by fifodate.
>
> ORDER BY is not allowed in subselects. This feature has been
> added in FB 1.5
> though.
>
>
> Dmitry
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>