Hi Greg,

Assuming your primary key is ID, you can find a list of the duplicates using:

SELECT id, COUNT( id) FROM ( table) GROUP BY id HAVING COUNT( id) > 1

This will return a list of all the records where the primary key appears at least twice. You could then set a relation to this file from the original to see the actual data.

Ian

>I need help writing the sql to return all the duplicate records in a table. The key fields are author and title and I need all the duplicates returned. If there is a duplicate record I need to see both. Any help would be appreciated.