>>PLEASE NOTE --- VFP8
>>
>>I need to get the records for a department based on the last time it was printed. I've got

>>SELECT dept,MAX(printtime) as pt ;
>>   FROM prn_status ;
>>   WHERE wono = ww ;
>>   GROUP BY dept ;
>>   INTO CURSOR curTemp
>>
>>SELECT p1.* ;
>>  FROM prn_status p1 ; 
>>    JOIN curTemp ct  ON p1.dept = ct.dept AND p1.printtime = ct.pt ;
>>  WHERE p1.wono = ww;
>>  INTO CURSOR crsData

>>
>>Is there a simple way to combine this into one query?
>>
>>Thanks to all..............Rich
>

>select p1.* from prn_Status p1
>where PrintTime = (select max(PrintTime) from prn_Status p where p.dept = p1.dept)

Thanks Naomi. I appreciate the help.

It turns out that it's MUCH faster to split it into two queries so I'm going to keep the original code.

Again, thanks

.......Rich