Skip to content

Query: Qry Principal Retention Process Steps

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

Tables Referenced

  • Product Principal Retention Process
  • Principal Retention Process Steps
  • Product

Columns Selected

  • [Product Principal Retention Process].[Product Principal Retention Process ID]
  • [Product Principal Retention Process].[Product ID]
  • [Principal Retention Process Steps].[Principal Retention Process Step]
  • [Product Principal Retention Process].[Month Number]
  • [Principal Retention Process Steps].[Sort Order]
  • [Product Principal Retention Process].[Step Number]

SQL

SELECT [Product Principal Retention Process].[Product Principal Retention Process ID], [Product Principal Retention Process].[Product ID], [Principal Retention Process Steps].[Principal Retention Process Step], [Product Principal Retention Process].[Month Number], [Principal Retention Process Steps].[Sort Order], [Product Principal Retention Process].[Step Number] FROM [Product Principal Retention Process], [Principal Retention Process Steps]