Hi Tony,

You make subquery a separte query and use it's result in the main query.

select DISTINCT TOP 2 date ;
	FROM tempAgg ;
	WHERE quarter = cPquart ;
	ORDER BY date ;
	INTO CURSOR crsTemp
	
SELECT * ;
 FROM tempAgg ;
 WHERE date in (select date FROM crsTemp) ;
 INTO CURSOR cuAgg 

USE IN crsTemp

>Hi Sergey,
>
>thanks for the response, although I'm a bit confused. How would you suggest I split my query?
>
>Thanks again,
>
>Tony