I have a table with the following fields: label, address, city, state and zip. I want to find all records in which the address, city, state and zip are the same but label is different. The problem I am having is there are two record for each match. One in which consigne matches contemp and one in which contemp matches consigne. For example, I would have one record in which o_labela = 13 and o_labelb = 25 and another record in which o_labela = 25 and o_labelb = 13. How do I eliminate this duplication? The following is my current SQL statement (note: contemp is just a copy of consigne):
select ;
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 ;
into table ;
(lcDatapath+'condupe.dbf')