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