Skip to content

Query: SubQry Process Status NOT in Pipeline List

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

Tables Referenced

  • Pipelines Detail
  • Pipelines

Columns Selected

  • [Pipelines Detail].[Pipeline Detail ID]
  • [Pipelines Detail].[Pipeline ID]
  • [Pipelines Detail].[Process Status ID]

Where Clause

((([Pipelines Detail].[Pipeline ID])=[Forms]![Frm Add and Edit Pipeline]![Pipeli

SQL

SELECT [Pipelines Detail].[Pipeline Detail ID], [Pipelines Detail].[Pipeline ID], [Pipelines Detail].[Process Status ID] FROM [Pipelines Detail] WHERE ((([Pipelines Detail].[Pipeline ID])=[Forms]![Frm Add and Edit Pipeline]![Pipeli