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--