Hi,

I am trying to identify the costs for products with the latest cost date. I am unable to run the query. Is there something that I can do?

SELECT PART,COST, DATE FROM DATA/COSTFILE AS T1 WHERE T1.DATE= (SELECT MAX(DATE) AS T2 FROM DATA/COSTFILE AS T2 WHERE T2.PART=T1.PART)

Thanks,

David

SELECT PART, COST, DATE
FROM COSTFILE T1
WHERE T1.DATE =
(SELECT MAX(DATE) FROM COSTFILE T2 WHERE T2.PART = T1.PART)