Unanswered: Help with duplicate contacts in Contact table
I'm new to SQL with 2 weeks under my belt....lol, so this may be a simple edit:
When I run the following query, I can get a list of all dups in the contact field:
COUNT(full_name) AS NumOccurrences
GROUP BY full_name
HAVING ( COUNT(full_name) > 1 )
I need to make sure I am de-activating (active = 0) only the contacts where they are listed more then once within the same company table (company.company_id) and the condition is that phone is NULL. I can't seem to make it work. Does anyone have any suggestions for an UPDATE I can use?