>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):
>

Add a group by...

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 ;
GROUP BY o_address1+o_address2+o_city+o_state+o_zip ;
INTO TABLE ;
   (lcDatapath+'condupe.dbf')