Skip to content

Query: Qry People Disciplinary Warning Letter List

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

Tables Referenced

  • People
  • People Disciplinary Warning Letters

Columns Selected

  • [People Disciplinary Warning Letters].[People Disciplinary Warning Letter ID]
  • [People Disciplinary Warning Letters].[People ID]
  • [People Disciplinary Warning Letters].[Date Issued]
  • [People Disciplinary Warning Letters].[Issued By]
  • Reason
  • [People Disciplinary Warning Letters].[Warning Level]
  • Validity
  • [People Disciplinary Warning Letters].[Expiry Date]

SQL

SELECT [People Disciplinary Warning Letters].[People Disciplinary Warning Letter ID], [People Disciplinary Warning Letters].[People ID], [People Disciplinary Warning Letters].[Date Issued], [People Disciplinary Warning Letters].[Issued By], [People Disciplinary Warning Letters].Reason, [People Disciplinary Warning Letters].[Warning Level], [People Disciplinary Warning Letters].Validity, [People Disciplinary Warning Letters].[Expiry Date] FROM [People Disciplinary Warning Letters]