Skip to content

Query: Qry Pipeline Detail List

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

Tables Referenced

  • Pipelines Detail
  • Pipelines
  • ProcessStatus

Columns Selected

  • [Pipelines Detail].[Pipeline ID]
  • [Pipelines Detail].[Pipeline Detail ID]
  • ProcessStatus.[Step Number]
  • Status
  • ProcessStatus.[Sort Order]
  • Active

Order By

[Pipelines Detail].[Pipeline ID], ProcessStatus.[Sort Order]

SQL

SELECT [Pipelines Detail].[Pipeline ID], [Pipelines Detail].[Pipeline Detail ID], ProcessStatus.[Step Number], ProcessStatus.Status, ProcessStatus.[Sort Order], ProcessStatus.Active FROM [Pipelines Detail], [ProcessStatus]