Find recaptures (duplicates) with SQL

recapture.sql

SELECT data_Animal.Species, data_Capture.WHno, data_Capture.CapDate, data_Capture.Recapture, data_Identification.Collar_Current_Freq, data_Identification.Collar_Current_ID
FROM (data_Animal INNER JOIN data_Capture ON data_Animal.WHno = data_Capture.WHno) LEFT JOIN data_Identification ON data_Capture.barcodeID = data_Identification.barcodeID
WHERE (data_Animal.Species="muld" Or data_Animal.Species="rmel") AND data_Capture.WHno IN
    (SELECT data_Capture.WHno
    FROM data_Capture
    GROUP BY data_Capture.WHno
    HAVING Count(data_Capture.WHno)>1)
ORDER BY data_Capture.WHno;