Skip to content

Query: Qry Count Training Modules One Job Code

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

Tables Referenced

  • Job
  • Job Code Training Modules

Columns Selected

  • [Job Code Training Modules].[Job ID]
  • Count([Job Code Training Modules].[Job Code Training Module ID])

SQL

SELECT [Job Code Training Modules].[Job ID], Count([Job Code Training Modules].[Job Code Training Module ID]) FROM [Job Code Training Modules]