Skip to content

Query: Qry Application List Not Hired

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

Tables Referenced

  • vwRubyPreApplicationListNotHired

Columns Selected

  • vwRubyPreApplicationListNotHired.[Application ID]
  • vwRubyPreApplicationListNotHired.[Position ID]
  • vwRubyPreApplicationListNotHired.[People ID]
  • vwRubyPreApplicationListNotHired.[Application Status ID]
  • vwRubyPreApplicationListNotHired.[Application Status]
  • Applicant
  • vwRubyPreApplicationListNotHired.[Application Date]
  • vwRubyPreApplicationListNotHired.[Sort Order]
  • vwRubyPreApplicationListNotHired.[PQ Score]

SQL

SELECT vwRubyPreApplicationListNotHired.[Application ID], vwRubyPreApplicationListNotHired.[Position ID], vwRubyPreApplicationListNotHired.[People ID], vwRubyPreApplicationListNotHired.[Application Status ID], vwRubyPreApplicationListNotHired.[Application Status], vwRubyPreApplicationListNotHired.Applicant, vwRubyPreApplicationListNotHired.[Application Date], vwRubyPreApplicationListNotHired.[Sort Order], vwRubyPreApplicationListNotHired.[PQ Score] FROM [vwRubyPreApplicationListNotHired]