Skip to content

Query: Qry Opal Scorecard Count Companies by Pgm Yr Status Not On Pgm

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

Tables Referenced

  • SubQry
  • SubQry Opal Scorecard Source

Columns Selected

  • [SubQry Opal Scorecard Source].[Programme Year Status]
  • Count([SubQry Opal Scorecard Source].[Entrepreneur Company ID])

Where Clause

((([SubQry Opal Scorecard Source].[Company Programme Year Status ID])<>1) AND ((

SQL

SELECT [SubQry Opal Scorecard Source].[Programme Year Status], Count([SubQry Opal Scorecard Source].[Entrepreneur Company ID]) FROM [SubQry Opal Scorecard Source] WHERE ((([SubQry Opal Scorecard Source].[Company Programme Year Status ID])<>1) AND ((