Skip to content

Query: Qry Sum Principal Participation Session by Phase and Product

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

Tables Referenced

  • Supplier Development
  • Product
  • Product Supplier Development

Columns Selected

  • [Product Supplier Development].[Product ID]
  • [Supplier Development].[Session Type]
  • [Product Supplier Development].[Phase Number]
  • Sum([Supplier Development].Number)

SQL

SELECT [Product Supplier Development].[Product ID], [Supplier Development].[Session Type], [Product Supplier Development].[Phase Number], Sum([Supplier Development].Number) FROM [Product Supplier Development], [Supplier Development]