Skip to content

Query: Qry Opal Scorecard Get Active Companies Stopped

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

Tables Referenced

  • SubQry
  • Entrepreneur Company
  • Entrepreneur Company Status History
  • SubQry Opal Scorecard Get Active Companies Stopped

Columns Selected

  • [SubQry Opal Scorecard Get Active Companies Stopped].[Date Status Changed]
  • [Entrepreneur Company Status History].[Entrepreneur Company ID]
  • [Entrepreneur Company Status History].[Company Status ID]
  • [Entrepreneur Company Status History].[Date Status Changed]

Where Clause

((([Entrepreneur Company Status History].[Company Status ID])=4 Or ([Entrepreneu

Order By

[SubQry Opal Scorecard Get Active Companies Stopped].[Date Status Changed]

SQL

SELECT [SubQry Opal Scorecard Get Active Companies Stopped].[Date Status Changed], [Entrepreneur Company Status History].[Entrepreneur Company ID], [Entrepreneur Company Status History].[Company Status ID], [Entrepreneur Company Status History].[Date Status Changed] FROM [SubQry Opal Scorecard Get Active Companies Stopped], [Entrepreneur Company], [Entrepreneur Company Status History] WHERE ((([Entrepreneur Company Status History].[Company Status ID])=4 Or ([Entrepreneu