Skip to content

Query: Qry Past Application List

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

Tables Referenced

  • Position Status
  • Positions
  • People
  • Applications
  • Job Codes
  • Application Status

Columns Selected

  • Applications.[People ID]
  • Applications.[Application ID]
  • Job
  • Applications.[Application Date]
  • [Application Status].[Application Status]
  • IIf(IsNull([Date Blacklisted]) Or [Date Blacklisted]=\

Order By

Applications.[People ID]

SQL

SELECT Applications.[People ID], Applications.[Application ID], [Job Codes].Job, Applications.[Application Date], [Application Status].[Application Status], IIf(IsNull([Date Blacklisted]) Or [Date Blacklisted]=\ FROM [People], [Applications], [Application Status], [Positions], [Position Status], [Job Codes]