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"

--
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase - Available Shortly