Skip to content

Query: SubQry People Training Sessions NOT in the List

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

Tables Referenced

  • People
  • People Training Sessions

Columns Selected

  • [People Training Sessions].[People Training Session ID]
  • [People Training Sessions].[People ID]
  • [People Training Sessions].[Job Code Training Session ID]

Where Clause

((([People Training Sessions].[People ID])=[Forms]![Frm People Training Informat

SQL

SELECT [People Training Sessions].[People Training Session ID], [People Training Sessions].[People ID], [People Training Sessions].[Job Code Training Session ID] FROM [People Training Sessions] WHERE ((([People Training Sessions].[People ID])=[Forms]![Frm People Training Informat