>Would not a
>GROUP BY PERS.pers_no
>before the order clause do this? Although there is no guarantee concerning which record from the multi-record table you'll get.
>
>Mike

Hi Mike,

Boy I must be asleep. This works. I don't care which phone is used.

Thanks.