Skip to content

Query: Qry Duplicate People

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

Tables Referenced

  • vwRubyDuplicatePeople

Columns Selected

  • vwRubyDuplicatePeople.[People ID]
  • Applicant
  • vwRubyDuplicatePeople.[Birth Date]
  • vwRubyDuplicatePeople.[ID Number]
  • vwRubyDuplicatePeople.[Application Date]
  • Job
  • vwRubyDuplicatePeople.[Application Status]

Order By

vwRubyDuplicatePeople.Applicant, vwRubyDuplicatePeople.[People ID]

SQL

SELECT vwRubyDuplicatePeople.[People ID], vwRubyDuplicatePeople.Applicant, vwRubyDuplicatePeople.[Birth Date], vwRubyDuplicatePeople.[ID Number], vwRubyDuplicatePeople.[Application Date], vwRubyDuplicatePeople.Job, vwRubyDuplicatePeople.[Application Status] FROM [vwRubyDuplicatePeople]