Skip to content

Query: Qry People Training Module List

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

Tables Referenced

  • People Training Modules
  • Training Types
  • Training Modules
  • People
  • Job Code Training Modules
  • Job Codes
  • People Training Module Status
  • Training Courses

Columns Selected

  • [People Training Modules].[People Training Module ID]
  • [People Training Modules].[People ID]
  • [Job Code Training Modules].[Training Type ID]
  • Job
  • [Training Types].[Training Type]
  • Course
  • Module
  • [People Training Modules].[Training Version]
  • [People Training Modules].[Date Scheduled]
  • [People Training Modules].[Date Completed]
  • [People Training Modules].[Quiz Score]
  • [People Training Modules].[Assessment Score]
  • [People Training Module Status].[People Training Module Status]
  • [Training Types].[Training Type Detail]

SQL

SELECT [People Training Modules].[People Training Module ID], [People Training Modules].[People ID], [Job Code Training Modules].[Training Type ID], [Job Codes].Job, [Training Types].[Training Type], [Training Courses].Course, [Training Modules].Module, [People Training Modules].[Training Version], [People Training Modules].[Date Scheduled], [People Training Modules].[Date Completed], [People Training Modules].[Quiz Score], [People Training Modules].[Assessment Score], [People Training Module Status].[People Training Module Status], [Training Types].[Training Type Detail] FROM [People Training Modules], [Job Code Training Modules], [Job Codes], [Training Courses], [Training Modules], [Training Types], [People Training Module Status]