Skip to content

Query: Qry People Training Sessions NOT in the List

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

Tables Referenced

  • Training
  • Training Sessions
  • SubQry People Training Sessions NOT in the List
  • 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]
  • [Training Types].[Training Type]
  • Course
  • Session
  • Quiz

Where Clause

((([SubQry People Training Sessions NOT in the List].[Job Code Training Session

SQL

SELECT [Job Code Training Sessions].[Job Code Training Session ID], [Job Code Training Sessions].[Job 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], [SubQry People Training Sessions NOT in the List] WHERE ((([SubQry People Training Sessions NOT in the List].[Job Code Training Session