Skip to content

Query: Qry Probation Review

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

Tables Referenced

  • People Probabtion Interviews
  • Probation Interview Types
  • Positions
  • People
  • Applications
  • Job Codes

Columns Selected

  • [Probation Interview Types].[Interview Type]
  • [People Probabtion Interviews].[Interviewed By]
  • [People Probabtion Interviews].[Interviewer Comments]
  • [People Probabtion Interviews].[Actions to be Taken]
  • [People Probabtion Interviews].[Perfromance Evaluation Score Reasons]
  • [People Probabtion Interviews].[Perfromance Evaluation Score]
  • [People].[First Name] & \
  • Positions.[Position Status ID]
  • [People_1].[First Name] & \
  • [People Probabtion Interviews].[People ID]
  • Job

Where Clause

(((Positions.[Position Status ID])=4) And (([People Probabtion Interviews].[Peop

SQL

SELECT [Probation Interview Types].[Interview Type], [People Probabtion Interviews].[Interviewed By], [People Probabtion Interviews].[Interviewer Comments], [People Probabtion Interviews].[Actions to be Taken], [People Probabtion Interviews].[Perfromance Evaluation Score Reasons], [People Probabtion Interviews].[Perfromance Evaluation Score], [People].[First Name] & \, Positions.[Position Status ID], [People_1].[First Name] & \, [People Probabtion Interviews].[People ID], [Job Codes].Job FROM [People], [People Probabtion Interviews], [Probation Interview Types], [People], [Applications], [Positions], [Job Codes] WHERE (((Positions.[Position Status ID])=4) And (([People Probabtion Interviews].[Peop