>>select membership.name;
>> from membership;
>> where membership.name = membership.name;
>> and membership.city = membership.city;
>> and membership.ssn <> membership.ssn;
>
>Yeah- I was hoping to do something like this, but this would result in a circular relation ship.
>
>I believe that the ultimate solution will involve several generations of sub tables and complex, multi field indexes.
>
>Thanks again for your input.

Erik,

It is perfectly valid to join a table to itself (though I may have the syntax wrong).

I hope you find what you are looking for.