>>Michael,
>>
>>Ok so change the group by to address1,adress2,city, zip
>
>None of those are unique. As I said, there are two of each record.
Michael,
Yes, but they are unqiue when taken together, are they not? If they aren't unique when taken together then I don't have an idea how you could do what you want as you have no unique value to group by. My suggestion is;
SELECT ...;
FROM ... ;
WHERE ... ;
GROUP BY Address1, Address2, City, Zip
That will group on the combination of all four fields and any record that completely duplicate the values for ALL FOUR fields will be rejected.