Skip to content

Query: Qry Job Code Training Sessions

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

Tables Referenced

  • Training
  • Training Sessions
  • Job Code Training Sessions
  • Training Courses
  • Training Types

Columns Selected

  • [Job Code Training Sessions].[Job Code Training Session ID]
  • [Job Code Training Sessions].[Job ID]
  • [Job Code Training Sessions].[Training Type ID]
  • [Training Types].[Training Type]
  • Course
  • Session
  • Quiz

SQL

SELECT [Job Code Training Sessions].[Job Code Training Session ID], [Job Code Training Sessions].[Job ID], [Job Code Training Sessions].[Training Type ID], [Training Types].[Training Type], [Training Courses].Course, [Training Sessions].Session, [Training Sessions].Quiz FROM [Training Courses], [Training Types], [Job Code Training Sessions], [Training Sessions]