Skip to content

Query: Qry Application List

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

Tables Referenced

  • vwRubyDuplicatePeopleIDList
  • vwRubyDuplicateApplicationList
  • vwRubyPreApplicationList

Columns Selected

  • vwRubyPreApplicationList.[Application ID]
  • vwRubyPreApplicationList.[Position ID]
  • vwRubyPreApplicationList.[People ID]
  • vwRubyDuplicatePeopleIDList.[Duplicate People ID]
  • vwRubyPreApplicationList.[Application Status ID]
  • vwRubyPreApplicationList.[Application Status]
  • IIf(Not IsNull([Duplicate People ID]),\
  • IIf(Not IsNull([Duplicate Application People ID]),\
  • Applicant
  • vwRubyPreApplicationList.[Application Date]
  • vwRubyPreApplicationList.[Sort Order]
  • Int(DateDiff(\
  • vwRubyPreApplicationList.[PQ Score]

SQL

SELECT vwRubyPreApplicationList.[Application ID], vwRubyPreApplicationList.[Position ID], vwRubyPreApplicationList.[People ID], vwRubyDuplicatePeopleIDList.[Duplicate People ID], vwRubyPreApplicationList.[Application Status ID], vwRubyPreApplicationList.[Application Status], IIf(Not IsNull([Duplicate People ID]),\, IIf(Not IsNull([Duplicate Application People ID]),\, vwRubyPreApplicationList.Applicant, vwRubyPreApplicationList.[Application Date], vwRubyPreApplicationList.[Sort Order], Int(DateDiff(\, vwRubyPreApplicationList.[PQ Score] FROM [vwRubyPreApplicationList], [vwRubyDuplicatePeopleIDList], [vwRubyDuplicateApplicationList]