Sorting further from a Duplicates Query

[Crackers]

I have a Duplicates Query that extract the following information from my Table

Name Surname DOB Joined

The query then extracts info such as...

Bill Smith 25:12:70 1999
Bill Smith 25:12:70 2005

Most of the time the 'Joined' field has the same year. But I need to find the ones where the year differs but the rest of the information is exactly the same. Because there is 15000 odd records to check, I thought that there would be a quicker way to check.

Could someone please assist me with this query if it is possible?

Thank you in advance.

 

[ByteMyzer]

You might try something along the lines of:

SELECT T1
FROM Table1 T1
WHERE EXISTS
(SELECT T2.*
FROM Table1 T2
WHERE T2.Name=T1.Name
AND T2.Surname=T1.Surname
AND T2.DOB=T1.DOB
AND T2.Joined<>T1.Joined;)
;

See if this works for you.