Skip to content

Query: Qry Edit Telephone Interview Question Responses

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

Tables Referenced

  • Telephone Interview Questions
  • Telephone Interview Question Categories
  • Application
  • Positions
  • People
  • Applications
  • Job Codes
  • Application Telephone Interview Question Responses
  • Pay Points

Columns Selected

  • [Telephone Interview Question Categories].[Sort Order]
  • [Telephone Interview Questions].[Sort Order]
  • [Application Telephone Interview Question Responses].[Application ID]
  • Job
  • [Pay Points].[Pay Point]
  • [First Name] & \
  • Applications.[Telephone Interviewer]
  • Applications.[Telephone Interview Date]
  • [Telephone Interview Question Categories].[Telephone Interview Question Category
  • [Telephone Interview Questions].[Telephone Interview Question]
  • [Telephone Interview Questions].[Telephone Interview Question Detail]
  • [Application Telephone Interview Question Responses].[Telephone Interview Respon

Order By

[Telephone Interview Question Categories].[Sort Order], [Telephone Interview Questions].[Sort Order]

SQL

SELECT [Telephone Interview Question Categories].[Sort Order], [Telephone Interview Questions].[Sort Order], [Application Telephone Interview Question Responses].[Application ID], [Job Codes].Job, [Pay Points].[Pay Point], [First Name] & \, Applications.[Telephone Interviewer], Applications.[Telephone Interview Date], [Telephone Interview Question Categories].[Telephone Interview Question Category, [Telephone Interview Questions].[Telephone Interview Question], [Telephone Interview Questions].[Telephone Interview Question Detail], [Application Telephone Interview Question Responses].[Telephone Interview Respon FROM [Application Telephone Interview Question Responses], [Telephone Interview Questions], [Telephone Interview Question Categories], [Applications], [Positions], [Job Codes], [People], [Pay Points]