SELECT a.field1, COUNT(*) AS Cnt FROM ParentTable AS a INNER JOIN ChildTable AS b ON a.field1 = b.field1 GROUP BY a.field1 HAVING (COUNT(*) > 1)
Select allOpen in new window
Open in new window