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

>
>I tried this and got an error: "O_ADDRESS1 is not unique and must be qualified." Remember, I have two records for each address set.

Excuse my ignorance, but if you actually have one table, it's probably a good idea not to copy it to another table, but run just
Select * From consigne Group by address,city,state,zip,label