Id 35, updated 8/14/25, 7:00 PM/master
Member selection - Name duplicates
SkyViewMember selections Create a copy
Edit
Name:
Name duplicates
Active:
Yes
Owned by system:
No

Selection SQL

sELECT InternalNo FROM Member WHERE Member.InternalNo IN (SELECT m1.InternalNo FROM Member m1 INNER JOIN Member m2 ON (m1.Lastname=m2.Lastname AND m1.Firstname=m2.Firstname AND m1.InternalNo<>m2.InternalNo));