Skip to content

Query: Qry Process Status NOT in Pipeline List

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

Tables Referenced

  • SubQry Process Status NOT in Pipeline List
  • ProcessStatus

Columns Selected

  • [SubQry Process Status NOT in Pipeline List].[Process Status ID]
  • ProcessStatus.[Process Status ID]
  • ProcessStatus.[Step Number]
  • Status
  • ProcessStatus.[Sort Order]
  • Active

Where Clause

((([SubQry Process Status NOT in Pipeline List].[Process Status ID]) Is Null) AN

Order By

ProcessStatus.[Sort Order]

SQL

SELECT [SubQry Process Status NOT in Pipeline List].[Process Status ID], ProcessStatus.[Process Status ID], ProcessStatus.[Step Number], ProcessStatus.Status, ProcessStatus.[Sort Order], ProcessStatus.Active FROM [ProcessStatus], [SubQry Process Status NOT in Pipeline List] WHERE ((([SubQry Process Status NOT in Pipeline List].[Process Status ID]) Is Null) AN