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 crsDataIs there a simple way to combine this into one query?