Query: Find duplicates for People Cell

Type: Select
Has Parameters: Yes
Has Joins: No
Has Subquery: Yes

Tables Referenced

• People

Columns Selected

• People.[First Name]
• People.[Last Name]
• People.[Cell Number]
• People.[People ID]

Where Clause

(((People.[First Name]) In (SELECT [First Name] FROM [People] As Tmp GROUP BY [F

Order By

People.[First Name], People.[Last Name], People.[Cell Number]

SQL

SELECT People.[First Name], People.[Last Name], People.[Cell Number], People.[People ID] FROM [People] WHERE (((People.[First Name]) In (SELECT [First Name] FROM [People] As Tmp GROUP BY [F