Skip to content

Query: SubQry Principal Journey Steps NOT in Process

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

Tables Referenced

  • Product Principal Journey
  • Product

Columns Selected

  • [Product Principal Journey].[Product Principal Journey ID]
  • [Product Principal Journey].[Product ID]
  • [Product Principal Journey].[Principal Journey Step ID]
  • [Product Principal Journey].[Month Number]
  • [Product Principal Journey].[Step Number]
  • [Product Principal Journey].[nPrincipal Journey Step ID]

Where Clause

((([Product Principal Journey].[Product ID])=[Forms]![Frm Add and Edit Product P

SQL

SELECT [Product Principal Journey].[Product Principal Journey ID], [Product Principal Journey].[Product ID], [Product Principal Journey].[Principal Journey Step ID], [Product Principal Journey].[Month Number], [Product Principal Journey].[Step Number], [Product Principal Journey].[nPrincipal Journey Step ID] FROM [Product Principal Journey] WHERE ((([Product Principal Journey].[Product ID])=[Forms]![Frm Add and Edit Product P