Hi, How can I eliminate Duplicate record by using this syntax:

sele x.pcode, y.pname from simain x, pcode y where x.pcode = y.pcode into cursor tempsale

Please note that simain is a sales invoice file which contains lots of duplicate pcode(Party Code).

Thanks