Skip to content

Query: Qry Sum Guiding Session Types by Type Phase and Product

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

Tables Referenced

  • Product
  • Guiding Sessions
  • Product Guiding Sessions

Columns Selected

  • [Product Guiding Sessions].[Product ID]
  • [Guiding Sessions].[Session Type]
  • [Product Guiding Sessions].[Phase Number]
  • Sum([Product Guiding Sessions].[Number of Sessions])

SQL

SELECT [Product Guiding Sessions].[Product ID], [Guiding Sessions].[Session Type], [Product Guiding Sessions].[Phase Number], Sum([Product Guiding Sessions].[Number of Sessions]) FROM [Product Guiding Sessions], [Guiding Sessions]