Skip to content

Query: Qry Job Code Application Steps NOT in List

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

Tables Referenced

  • SubQry Job Code Application Step NOT in List
  • Application
  • Application Status

Columns Selected

  • [Application Status].[Application Status ID]
  • [Application Status].[Application Status]
  • [Application Status].[Sort Order]
  • Active

Where Clause

((([SubQry Job Code Application Step NOT in List].[Application Status ID]) Is Nu

SQL

SELECT [Application Status].[Application Status ID], [Application Status].[Application Status], [Application Status].[Sort Order], [Application Status].Active FROM [Application Status], [SubQry Job Code Application Step NOT in List] WHERE ((([SubQry Job Code Application Step NOT in List].[Application Status ID]) Is Nu