select ;
consigne.PrimeryKey, ;
consigne.o_label AS o_labela, ;
contemp.o_label AS o_labelb, ;
consigne.o_address1,;
consigne.o_address2, ;
consigne.o_city, ;
consigne.o_state, ;
consigne.o_zip ;
from ;
consigne, contemp ;
where ;
consigne.o_label contemp.o_label AND ;
consigne.o_address1 = contemp.o_address1 AND ;
consigne.o_address2 = contemp.o_address2 AND ;
consigne.o_city = contemp.o_city AND;
consigne.o_state = contemp.o_state AND ;
consigne.o_zip = contemp.o_zip ;
group by 1 ;
into table ;
(lcDatapath+'condupe.dbf')
By adding the PK from the table and grouping on it you will eliminate any dups of a record from the result.