>>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

I did a quick test and neither solution seems to work. But no worries, I was able to eliminate the second SQL statement altogether. Still wondering, though...