Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Another SQL Question
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00609453
Message ID:
00609458
Views:
11
SELECT DISTINCT EntryDate, BatchId;
  FROM Resh;
  ORDER BY EntryDate;
  INTO CURSOR Temp1
>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
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform