Simple Code Improvement Question

[GriffyNJ]

I'm working on the following SQL for a query:

SELECT PERSON_NAME.Person_id, PERSON_NAME.delete, PERSON_NAME.Lastname_name_local1, PERSON_NAME.Person_name_id, PERSON_NAME.Middle_name, PERSON_NAME.Name_suffix
FROM PERSON_NAME
WHERE (((PERSON_NAME.person_id) In (SELECT [person_id] FROM [PERSON_NAME] As Tmp GROUP BY [person_id] HAVING Count(*)>1 )))
ORDER BY PERSON_NAME.Person_id;

I simply want to add to this code the ability to select not only person_id's that have a count greater that one, I want to select both person_id's AND lastname's that have a count greater than one. What should I do to improve the code?

 

[ByteMyzer]

You might try:

SELECT PERSON_NAME.Person_id, PERSON_NAME.delete,
       PERSON_NAME.Lastname_name_local1, PERSON_NAME.Person_name_id,
       PERSON_NAME.Middle_name, PERSON_NAME.Name_suffix
FROM PERSON_NAME
WHERE PERSON_NAME.person_id In (
      SELECT Tmp1.person_id
      FROM PERSON_NAME As Tmp1
      GROUP BY Tmp1.person_id
      HAVING Count(*) > 1
) OR PERSON_NAME.Lastname_name_local1 In (
     SELECT Tmp2.Lastname_name_local1
     FROM PERSON_NAME As Tmp2
     GROUP BY Tmp2.Lastname_name_local1
     HAVING Count(*) > 1
) ORDER BY PERSON_NAME.Person_id;