Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Selecting data where field = max(field)
Message
From
02/11/2011 19:02:09
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Selecting data where field = max(field)
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
01527898
Message ID:
01527898
Views:
73
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
Next
Reply
Map
View

Click here to load this message in the networking platform