SELECT name1,CNT(*) as cnt from clients GROUP BY name1 HAVING cnt > 1>I have two tables in a mother-daughter relationship. I want to scan through the mother table looking for duplicate records (just need to compare one field) in the daughter table. Is there a slick way to do this?