At 08:57 AM 5/24/2003 +0100, you wrote:

>In article <5.1.1.6.2.20030524001153.085c3a60@192.168.0.100>, Joe Martinez
>wrote:
> > 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.

-Joe