Skip to content

Query: SubQry Product Purple Process Steps NOT in Process

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

Tables Referenced

  • Product Purple Process
  • Product

Columns Selected

  • [Product Purple Process].[Product Purple Process ID]
  • [Product Purple Process].[Product ID]
  • [Product Purple Process].[Purple Process Step ID]
  • [Product Purple Process].[Step Number]

Where Clause

((([Product Purple Process].[Product ID])=[Forms]![Frm Add and Edit Product Purp

SQL

SELECT [Product Purple Process].[Product Purple Process ID], [Product Purple Process].[Product ID], [Product Purple Process].[Purple Process Step ID], [Product Purple Process].[Step Number] FROM [Product Purple Process] WHERE ((([Product Purple Process].[Product ID])=[Forms]![Frm Add and Edit Product Purp