Active record INNER JOIN to search for duplicate records

[eluser]Unknown[/eluser]
Thanks for the reply. I tried using COUNT with HAVING, but with that method the results only show 1 row for each group of duplicates. I need to show each duplicate record individually.