Skip to content

Query: Qry Product Purple Process Steps NOT in Process

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

Tables Referenced

  • SubQry
  • SubQry Product Purple Process Steps NOT in Process
  • Purple Process Steps

Columns Selected

  • [Purple Process Steps].[Purple Process Step ID]
  • [Purple Process Steps].[Purple Process Step]
  • [Purple Process Steps].[Purple Process Step Details]
  • [Purple Process Steps].[Conditional on Step]
  • [Purple Process Steps].[Sort Order]

Where Clause

((([SubQry Product Purple Process Steps NOT in Process].[Purple Process Step ID]

SQL

SELECT [Purple Process Steps].[Purple Process Step ID], [Purple Process Steps].[Purple Process Step], [Purple Process Steps].[Purple Process Step Details], [Purple Process Steps].[Conditional on Step], [Purple Process Steps].[Sort Order] FROM [SubQry Product Purple Process Steps NOT in Process], [Purple Process Steps] WHERE ((([SubQry Product Purple Process Steps NOT in Process].[Purple Process Step ID]