Skip to content

Query: SubQry Job Code Training Modules NOT in the List

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

Tables Referenced

  • Job
  • Job Code Training Modules

Columns Selected

  • [Job Code Training Modules].[Job Code Training Module ID]
  • [Job Code Training Modules].[Job ID]
  • [Job Code Training Modules].[Training Module ID]
  • [Job Code Training Modules].[Sort Order]

Where Clause

((([Job Code Training Modules].[Job ID])=[Forms]![Frm View Job Code Training Mod

SQL

SELECT [Job Code Training Modules].[Job Code Training Module ID], [Job Code Training Modules].[Job ID], [Job Code Training Modules].[Training Module ID], [Job Code Training Modules].[Sort Order] FROM [Job Code Training Modules] WHERE ((([Job Code Training Modules].[Job ID])=[Forms]![Frm View Job Code Training Mod