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