Member selection - Name duplicates
Member selections
Member selection
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));
Members (2)
| Name | Member no | License info |
|---|---|---|
| Penelope Clearwater | 2127 | 2026 / DEMO / D / HM AFF |
| Penelope Clearwater | 2128 | 2026 / DEMO / D / HM AFF |