Skip to content

Query: Qry SubRpt Product Ignition Activities

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

Tables Referenced

  • Product Ignition Activities
  • Product
  • Ignition Activity LookUp

Columns Selected

  • [Product Ignition Activities].[Product ID]
  • [Ignition Activity LookUp].[Ignition Activity]
  • [Product Ignition Activities].[Ignition Activity Type Phase 1]
  • [Product Ignition Activities].[Ignition Activity Type Phase 2]
  • [Product Ignition Activities].[Ignition Activity Type Phase 3]

SQL

SELECT [Product Ignition Activities].[Product ID], [Ignition Activity LookUp].[Ignition Activity], [Product Ignition Activities].[Ignition Activity Type Phase 1], [Product Ignition Activities].[Ignition Activity Type Phase 2], [Product Ignition Activities].[Ignition Activity Type Phase 3] FROM [Product Ignition Activities], [Ignition Activity LookUp]