Skip to content

Query: Qry Process Status List Digital Pipelines

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

Tables Referenced

  • Pipelines Detail
  • Pipelines
  • ProcessStatus

Columns Selected

  • Pipelines.[Selection Type]
  • ProcessStatus.[Process Status ID]
  • ProcessStatus.[Step Number]
  • Status
  • ProcessStatus.[Sort Order]
  • Active

Where Clause

(((Pipelines.[Selection Type])=2))

SQL

SELECT Pipelines.[Selection Type], ProcessStatus.[Process Status ID], ProcessStatus.[Step Number], ProcessStatus.Status, ProcessStatus.[Sort Order], ProcessStatus.Active FROM [Pipelines], [Pipelines Detail], [ProcessStatus] WHERE (((Pipelines.[Selection Type])=2))