Skip to content

Query: Qry People Disciplinary Investigation Process List

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

Tables Referenced

  • People
  • People Disciplinary Investigation Process

Columns Selected

  • [People Disciplinary Investigation Process].[People Disciplinary Investigation P
  • [People Disciplinary Investigation Process].[People ID]
  • [People Disciplinary Investigation Process].[Date Started]
  • [People Disciplinary Investigation Process].[Started By]
  • Reason
  • Notes
  • [People Disciplinary Investigation Process].[Date Closed]
  • Result

SQL

SELECT [People Disciplinary Investigation Process].[People Disciplinary Investigation P, [People Disciplinary Investigation Process].[People ID], [People Disciplinary Investigation Process].[Date Started], [People Disciplinary Investigation Process].[Started By], [People Disciplinary Investigation Process].Reason, [People Disciplinary Investigation Process].Notes, [People Disciplinary Investigation Process].[Date Closed], [People Disciplinary Investigation Process].Result FROM [People Disciplinary Investigation Process]