Skip to content

Query: Qry SubRpt Product Entrepreneurial Growth Criteria

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

Tables Referenced

  • Product Entrepreneurial Growth Criteria
  • Product
  • Entrepreneurial Growth Criteria LookUp

Columns Selected

  • [Product Entrepreneurial Growth Criteria].[Product Entrepreneurial Growth Criter
  • [Product Entrepreneurial Growth Criteria].[Product ID]
  • [Entrepreneurial Growth Criteria LookUp].[Entrepreneurial Growth Category]
  • [Entrepreneurial Growth Criteria LookUp].[Entrepreneurial Growth Criteria]
  • [Entrepreneurial Growth Criteria LookUp].[Sort Order]
  • [Product Entrepreneurial Growth Criteria].[EP Growth Phase 1]
  • [Product Entrepreneurial Growth Criteria].[EP Growth Phase 2]
  • [Product Entrepreneurial Growth Criteria].[EP Growth Phase 3]

SQL

SELECT [Product Entrepreneurial Growth Criteria].[Product Entrepreneurial Growth Criter, [Product Entrepreneurial Growth Criteria].[Product ID], [Entrepreneurial Growth Criteria LookUp].[Entrepreneurial Growth Category], [Entrepreneurial Growth Criteria LookUp].[Entrepreneurial Growth Criteria], [Entrepreneurial Growth Criteria LookUp].[Sort Order], [Product Entrepreneurial Growth Criteria].[EP Growth Phase 1], [Product Entrepreneurial Growth Criteria].[EP Growth Phase 2], [Product Entrepreneurial Growth Criteria].[EP Growth Phase 3] FROM [Product Entrepreneurial Growth Criteria], [Entrepreneurial Growth Criteria LookUp]