Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Another SQL Question
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Another SQL Question
Divers
Thread ID:
00609453
Message ID:
00609453
Vues:
53
How do I select out all records with a distinct combination of 2 fields?

SELECT EntryDate, BatchId;
  FROM Resh;
  ORDER BY EntryDate;
  INTO CURSOR Temp1


This gives me ALL records. I just want the records where the combination
of the 2 fields are unique.

Thanks
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform