Skip to content

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

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

Tables Referenced

  • Learning Sessions
  • Product
  • Product Learning Sessions

Columns Selected

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

Where Clause

((([Learning Sessions].[Session Name])<>\"Engauge\"))

SQL

SELECT [Product Learning Sessions].[Product ID], [Learning Sessions].[Session Type], [Product Learning Sessions].[Phase Number], Sum([Product Learning Sessions].[Number of Sessions]) FROM [Product Learning Sessions], [Learning Sessions] WHERE ((([Learning Sessions].[Session Name])<>\"Engauge\"))