isolating primary keys from other distinct fields

I am using an Informix SE Database to catalog user names. I have duplicate entries for people that entered information more than once but each entry is listed by it's unique primary key. I have been trying to isolate the primary key by doing a "select distinct" across the other fields and placing the information in a temp table to have the permanent table check against. But if I select the distinct entries and iunclude the primary key it returns every entry since every primary key is distinct. If I do not include the primary key in the query that field is not placed in the temp table and I cannot check against the primary keys. I also tried a subquery but cannot seem to use a select distinct in the subquery. Can anyone out there help me? Kevi -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own