Skip to content

Query: Qry SubFrm Product Pricing Header Display

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

Tables Referenced

  • Products

Columns Selected

  • Products.[Product ID]
  • Products.[Minimum Cohort Size]
  • [Phase 1 Duration Weeks]+[Phase 2 Duration Weeks]+[Phase 3 Duration Weeks]
  • [Phase 1 Duration Months]+[Phase 2 Duration Months]+[Phase 3 Duration Months]
  • [Phase 1 Duration Years]+[Phase 2 Duration Years]+[Phase 3 Duration Years]

SQL

SELECT Products.[Product ID], Products.[Minimum Cohort Size], [Phase 1 Duration Weeks]+[Phase 2 Duration Weeks]+[Phase 3 Duration Weeks], [Phase 1 Duration Months]+[Phase 2 Duration Months]+[Phase 3 Duration Months], [Phase 1 Duration Years]+[Phase 2 Duration Years]+[Phase 3 Duration Years] FROM [Products]