Skip to content

Query: SubQry Rpt Opal Principal Projects by Industry

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

Tables Referenced

  • Principal Project Pillars
  • Principal
  • Principal Projects
  • Principals
  • IndustryLookup

Columns Selected

  • Industry
  • [Principal Projects].[Principal Project ID]
  • [Principal] & \
  • Sum([Principal Project Pillars].[Number of Companies Required])
  • [Principal Projects].[Principal Project Status ID]

Order By

[Principal] & \

SQL

SELECT IndustryLookup.Industry, [Principal Projects].[Principal Project ID], [Principal] & \, Sum([Principal Project Pillars].[Number of Companies Required]), [Principal Projects].[Principal Project Status ID] FROM [Principal Projects], [Principals], [IndustryLookup], [Principal Project Pillars]