Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can this be done in one SQL Select?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00984864
Message ID:
00984904
Vues:
29
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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform