Skip to content

Query: Qry SubRpt Product Principal Journey

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

Tables Referenced

  • Product Principal Journey
  • Principal Journey Steps
  • Product

Columns Selected

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

SQL

SELECT [Product Principal Journey].[Product Principal Journey ID], [Product Principal Journey].[Product ID], [Principal Journey Steps].[Principal Journey Step], [Product Principal Journey].[Month Number], [Product Principal Journey].[Step Number] FROM [Product Principal Journey], [Principal Journey Steps]