Skip to content

Query: Qry Merge Duplicate People Source

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

Tables Referenced

  • Position Status
  • Positions
  • Applications
  • Job Codes
  • Qry
  • Application Status
  • Qry Find Dulicate People for Merge

Columns Selected

  • [Qry Find Dulicate People for Merge].[First Name]
  • [Qry Find Dulicate People for Merge].[Last Name]
  • [Qry Find Dulicate People for Merge].[ID Number]
  • Applications.[People ID]
  • Applications.[Application ID]
  • [Application Status].[Application Status]
  • [Position Status].[Position Status]
  • Job

Order By

[Qry Find Dulicate People for Merge].[ID Number], Applications.[People ID]

SQL

SELECT [Qry Find Dulicate People for Merge].[First Name], [Qry Find Dulicate People for Merge].[Last Name], [Qry Find Dulicate People for Merge].[ID Number], Applications.[People ID], Applications.[Application ID], [Application Status].[Application Status], [Position Status].[Position Status], [Job Codes].Job FROM [Qry Find Dulicate People for Merge], [Applications], [Positions], [Job Codes], [Application Status], [Position Status]