>Hi Nadya,
>I'm trying to find ssnumbers that have two of my insurance (comapny1 and company2)
>comanys related to the same ssnumber. All of the insurance companys have a ssnumber fiel.
>
>But I think I can use your example, as a newbe haven't seen it expressed this way before.
>
>Thanks
>John

Actually, it's a standard way to identify duplicates in a table.

select *, count(*) as cnt_dups from table TableName group by Field_which_may_contain_dups having cnt_dups>1 into table Dups

Next step:
2. select dups
index on Field_which_may_contain_dups tag DupField && in your case ssnumber

3. select your table
set relation into dups on ssnumber

4. Browse both tables (YourTable on top, dups in the bottom):
and decide, what do you want to do with duplicates.