Skip to content

Query: Find duplicates for Job Code Training Sessions

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

Tables Referenced

  • Job Code Training Sessions
  • Job

Columns Selected

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

Where Clause

((([Job Code Training Sessions].[Job ID]) In (SELECT [Job ID] FROM [Job Code Tra

Order By

[Job Code Training Sessions].[Job ID], [Job Code Training Sessions].[Training Session ID]

SQL

SELECT [Job Code Training Sessions].[Job ID], [Job Code Training Sessions].[Training Session ID], [Job Code Training Sessions].[Job Code Training Session ID] FROM [Job Code Training Sessions] WHERE ((([Job Code Training Sessions].[Job ID]) In (SELECT [Job ID] FROM [Job Code Tra