>Hi
>
>I have a list of individuals with a key of individual_ref
>those individuals can be linked to a partner by family_ref
>
>so I would have a row
>
>individual_ref family ref
>58056 174279
>174279 58056
>
>I am selecting a random number of individual but I don't want partners to be selected
>
>How can I do that.
>
>Thanks
>
>Nick


UPDATE:
I just saw that your data has cross reference. How do you know what is partner and what is family?
From the data you provided which record you want?