you can do like this also....
your main table is paid table.....
insert all data of paid table in table2....
and again insert data in temp table and by using distinct...
you got your output without duplication...in table2....
display table2....
and your paid table remain as original....