Skip to content

Query: SubQry Job Code Application Step NOT in List

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

Tables Referenced

  • Application Status
  • Job Code Application Steps
  • Job

Columns Selected

  • [Job Code Application Steps].[Job Code Application Step ID]
  • [Job Code Application Steps].[Job ID]
  • [Job Code Application Steps].[Application Status ID]
  • [Application Status].[Application Status]
  • [Application Status].[Sort Order]
  • Active

Where Clause

((([Job Code Application Steps].[Job ID])=[Forms]![Frm Configure Job Application

SQL

SELECT [Job Code Application Steps].[Job Code Application Step ID], [Job Code Application Steps].[Job ID], [Job Code Application Steps].[Application Status ID], [Application Status].[Application Status], [Application Status].[Sort Order], [Application Status].Active FROM [Job Code Application Steps], [Application Status] WHERE ((([Job Code Application Steps].[Job ID])=[Forms]![Frm Configure Job Application