Hi Cetin,
you are right.
I have focused to much on the definition of the superfluous records. Your way to define the records to keep is better.
Agnes
>When you have the select, delete is easier.
>
>
Select t1.* From Schnaps t1 ;
> INNER Join ;
> (Select Min(iOrder) As iOrder From Schnaps Group By c3) t2 ;
> ON t1.iOrder == t2.iOrder
>
>
>Delete From Schnaps Where iOrder Not In ;
> (Select Min(iOrder) As iOrder From Schnaps Group By c3)
>
>
>IMHO message#
1416414 is more complex than needed.
>
>Cetin
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]