>Hi All:
>
>I have a table of deliveries of widgets to various customers.
>
>
>Cust Delivery Date
>1111 3/1/09
>1111 4/1/09
>2222 3/2/09
>3333 3/1/09
>3333 4/5/09
>
>
>How do I say:
>
>Select the 1 record for each customer containing the earliest delivery date?
>
>Thanks,
>
>Yossi
SELECT Cust, MIN(Delivery) AS Delivery;
FROM YourTable;
GROUP BY Cust;
INTO CURSOR crsSelect
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst
