Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can this be done in one SQL Select?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00984864
Message ID:
00984904
Views:
33
This message has been marked as a message which has helped to the initial question of the thread.
If You want that fields to be theese where the MAX(Ord_Time) is then SELECT Must Be
SELECT Cust_Id, Ord_Date, Ord_Time (more fields) FROM Cust_Id WHERE TRANSFORM(Cust_Id)+TRANSFORM(Ord_Time) IN (SELECT TRANSFORM(Cust_Id)+MAX(TRANSFORM(Ord_Time)) FROM Cust_Id GROUP BY Cuts_Id) .AND. Ord_Date = YourDate [INTO ....]
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform