Skip to content

Query: SubQry Job Codes and Training Module Types List

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

Tables Referenced

  • Job
  • Job Code Training Modules
  • Training Types

Columns Selected

  • [Training Types].[Training Type]
  • [Job Code Training Modules].[Training Type ID]
  • [Job Code Training Modules].[Job ID]

Order By

[Training Types].[Training Type]

SQL

SELECT [Training Types].[Training Type], [Job Code Training Modules].[Training Type ID], [Job Code Training Modules].[Job ID] FROM [Job Code Training Modules], [Training Types]