>Hi All:
>
>Why am I getting the following message on the second SQL statement?
>
>Alias 'CURTEMP' not found
>
>When I do a suspend just before the 2nd SQL statement I can see the alias CURTEMP!
>
>

>SELECT Foo.Custno, Foo.ITEM, Foo.DATE, MAX(Foo.CustPrice) AS CustPrice, MAX(Foo.CustCost) AS CustCost ;
>	FROM ( ;           												&&Open Paren 1
>	SELECT a_artran.Custno Custno, ;                                                              
>	a_artran.ITEM ITEM, ;
>	a_artran.price CustPrice, ;
>	a_artran.cost CustCost, ;
>	a_armast.invdte DATE ;
>	FROM a_artran ;
>	INNER JOIN a_armast ;
>	ON a_armast.invno = a_artran.invno ;
>	WHERE a_armast.invdte > DATE() - 400 ;
>	UNION ALL ;
>	SELECT a_arytrn.Custno Custno, ;
>	a_arytrn.ITEM ITEM, ;
>	a_arytrn.price CustPrice, ;
>	a_arytrn.cost CustCost, ;
>	a_arymst.invdte DATE ;
>	FROM a_arytrn ;
>	INNER JOIN a_arymst ;
>	ON a_arymst.invno = a_arytrn.invno ;
>	WHERE a_arymst.invdte > DATE() - 400 ;
>	) Foo ;                                							&&Close Paren 1
>	INNER JOIN ( ;													&&Open paren 2
>	SELECT Custno, ITEM, MAX(DATE) AS DATE ;                       
>	FROM ( ;                                                        &&Open paren 3
>	SELECT a_artran.Custno Custno, a_artran.ITEM ITEM, a_armast.invdte DATE ;    
>	FROM a_artran ;
>	INNER JOIN a_armast ;
>	ON a_armast.invno = a_artran.invno ;
>	WHERE a_armast.invdte > DATE() - 400 ;
>	UNION ALL;
>	SELECT a_arytrn.Custno Custno, a_arytrn.ITEM ITEM, a_arymst.invdte DATE ;
>	FROM a_arytrn ;
>	INNER JOIN a_arymst ;
>	ON a_arymst.invno = a_arytrn.invno ;
>	WHERE a_arymst.invdte > DATE() - 400 ;
>	) Foo ;															&&Close paren 3
>	GROUP BY Custno, ITEM ;
>	) Foo1 ;														&&Close paren 2
>	ON Foo.Custno = Foo1.Custno ;
>	AND Foo.ITEM = Foo1.ITEM ;
>	AND Foo.DATE = Foo1.DATE ;
>	GROUP BY Foo.Custno, Foo.ITEM, Foo.DATE ;
>	INTO CURSOR curTemp
>	
>	SELECT curTemp.*, a_icpric.unitpr1 PricPrice ;
>	FROM curTemp ;
>	outer JOIN a_icpric ;
>	ON curTemp.item = a_icpric.item ;
>	AND curTemp.custno = a_icpric.custno ;
>	INTO CURSOR curLatestPrices
>

>
>Thanks,
>
>Yossi


If James' suggestion doesn't work try

SELECT DBF( curTemp).*, a_icpric.unitpr1 PricPrice ;
FROM DBF(curTemp) ;

etc