Skip to content

Query: Qry Report 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
  • Qry Get Reporting To Name and Job
  • Job Codes
  • Application Telephone Interview Question Responses

Columns Selected

  • [Application Telephone Interview Question Responses].[Application ID]
  • [Telephone Interview Questions].[Do Not Print This Question]
  • Job
  • [People].[First Name] & \
  • People.[Cell Number]
  • [Qry Get Reporting To Name and Job].[Reporting To Job]
  • Applications.[Telephone Interviewer]
  • Applications.[Telephone Interview Date]
  • [Telephone Interview Question Categories].[Telephone Interview Question Category
  • [Telephone Interview Question Categories].[Sort Order]
  • [Telephone Interview Questions].[Telephone Interview Question]
  • [Telephone Interview Questions].[Telephone Interview Question Detail]
  • [Telephone Interview Questions].[Sort Order]
  • [Application Telephone Interview Question Responses].[Telephone Interview Respon

Where Clause

((([Telephone Interview Questions].[Do Not Print This Question])=No))

Order By

[Application Telephone Interview Question Responses].[Application ID], [Telephone Interview Question Categories].[Sort Order], [Telephone Interview Questions].[Sort Order]

SQL

SELECT [Application Telephone Interview Question Responses].[Application ID], [Telephone Interview Questions].[Do Not Print This Question], [Job Codes].Job, [People].[First Name] & \, People.[Cell Number], [Qry Get Reporting To Name and Job].[Reporting To Job], Applications.[Telephone Interviewer], Applications.[Telephone Interview Date], [Telephone Interview Question Categories].[Telephone Interview Question Category, [Telephone Interview Question Categories].[Sort Order], [Telephone Interview Questions].[Telephone Interview Question], [Telephone Interview Questions].[Telephone Interview Question Detail], [Telephone Interview Questions].[Sort Order], [Application Telephone Interview Question Responses].[Telephone Interview Respon FROM [Application Telephone Interview Question Responses], [Applications], [People], [Positions], [Job Codes], [Telephone Interview Questions], [Telephone Interview Question Categories], [Qry Get Reporting To Name and Job] WHERE ((([Telephone Interview Questions].[Do Not Print This Question])=No))