Sorry Don, that is not distinct by a.fld1, a.flds2

Table Dodah
A B
1 Osburn
2 Agostinelli

Table Blah
AC D
Jackson 39185
Vicksburg 39180
Vicksburg 3
>Try something like...
>
>

>select distinct;
>    a.Fld1,;
>    a.Fld2,;
>    b.Fld3,;
>    c.Fld4,;
>    c.Fld5;
>  From;
>    Dodah a,;
>    Blah b,;
>    Big c;
>  where;
>        a.KeyFld1 = b.KeyFld1;
>    AND a.KeyFld1 = c.KeyFld1;
>  order by;
>    a.Fld1,;
>    b.Fld3,;
>    c.Fld4;
>  into;
>    cursor C_DistinctSampleSet
>

>
>Your sample fields / tables illustrated ok to some point, but hopefully, you follow the above SQL. I don't know what your REAL join key columns are, but you SHOULD be able to substitute accordingly.
>
>HTH,
>
>Don