Skip to content

Query: Qry Job Code Training Modules NOT in the List

Type: Delete
Has Parameters: No
Has Joins: No
Has Subquery: No

Tables Referenced

  • Training Modules
  • SubQry Job Code Training Modules NOT in the List
  • SubQry

Columns Selected

  • [Training Modules].[Training Module ID]
  • Module
  • [SubQry Job Code Training Modules NOT in the List].[Sort Order]

Where Clause

((([SubQry Job Code Training Modules NOT in the List].[Training Module ID]) Is N

SQL

SELECT [Training Modules].[Training Module ID], [Training Modules].Module, [SubQry Job Code Training Modules NOT in the List].[Sort Order] FROM [SubQry Job Code Training Modules NOT in the List], [Training Modules] WHERE ((([SubQry Job Code Training Modules NOT in the List].[Training Module ID]) Is N