Skip to content

Query: Qry SubRpt Product Financial Growth Criteria

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

Tables Referenced

  • Financial Growth Criteria LookUp
  • Product Financial Growth Criteria
  • Product

Columns Selected

  • [Product Financial Growth Criteria].[Product Financial Growth Criteria ID]
  • [Product Financial Growth Criteria].[Product ID]
  • [Financial Growth Criteria LookUp].[Financial Growth Criteria]
  • [Financial Growth Criteria LookUp].[Sort Order]
  • [Product Financial Growth Criteria].[Financial Growth Phase 1]
  • [Product Financial Growth Criteria].[Financial Growth Phase 2]
  • [Product Financial Growth Criteria].[Financial Growth Phase 3]

SQL

SELECT [Product Financial Growth Criteria].[Product Financial Growth Criteria ID], [Product Financial Growth Criteria].[Product ID], [Financial Growth Criteria LookUp].[Financial Growth Criteria], [Financial Growth Criteria LookUp].[Sort Order], [Product Financial Growth Criteria].[Financial Growth Phase 1], [Product Financial Growth Criteria].[Financial Growth Phase 2], [Product Financial Growth Criteria].[Financial Growth Phase 3] FROM [Product Financial Growth Criteria], [Financial Growth Criteria LookUp]