Table without Key column

Hi guys,

I am almost stuck with one report requirement which is to remove duplicate records. Duplicate records come from a table which does not have any Primary key/Foreign key/Unique constraint and that's why so many repeating records.

Now one of these columns is used in a join to extract other information from different tables. But when i try to fetch using DISTINCT query goes in infinite loop and does not respond.

Can anybody suggest me a solution to this problem at BO level? Do I tell Business analyst that the source of problem lies in the table without any key.?

Thanks,

Manish Amin