Skip to content

Query: SubQry Product Jade Process Steps NOT in Process

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

Tables Referenced

  • Product
  • Product Jade Process

Columns Selected

  • [Product Jade Process].[Product Jade Process ID]
  • [Product Jade Process].[Product ID]
  • [Product Jade Process].[Jade Process Step ID]
  • [Product Jade Process].[Step Number]
  • [Product Jade Process].[nJade Process Step ID]

Where Clause

((([Product Jade Process].[Product ID])=[Forms]![Frm Add and Edit Product Jade P

SQL

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