Obviously the id will be unique for each record. What would constitute a duplicate would be matching data in the following columns:
- p.first
- p.last
- a.address1
- a.city
- a.postalcode1
I've never done joins across tables to determine duplication for a query such as this. What I would need returned would be a list of the lowest id column value for each duplicate instance. There are cases where there are multiple 'duplicates'. Any help will be greatly appreciated. Thank you.