Skip to content

Query: Qry SubRpt Product Selection Assessment

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

Tables Referenced

  • Product
  • Product Selection Criteria and Assessment
  • Jocky-Horse Scale Lookup

Columns Selected

  • [Product Selection Criteria and Assessment].[Product ID]
  • [Product Selection Criteria and Assessment].[Phase Number]
  • [Product Selection Criteria and Assessment].[Baseline Audit Principal Requiremen
  • [Jocky-Horse Scale Lookup].[Jocky-Horse Scale]
  • Description

SQL

SELECT [Product Selection Criteria and Assessment].[Product ID], [Product Selection Criteria and Assessment].[Phase Number], [Product Selection Criteria and Assessment].[Baseline Audit Principal Requiremen, [Jocky-Horse Scale Lookup].[Jocky-Horse Scale], [Jocky-Horse Scale Lookup].Description FROM [Product Selection Criteria and Assessment], [Jocky-Horse Scale Lookup]