Skip to content

Query: SubQry Get Raizcorp Possibles Position

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

Tables Referenced

  • SubQry Get Moved Last Week to Active PP Allocated Exited
  • SubQry
  • Entrepreneur Company Status History

Columns Selected

  • [Entrepreneur Company Status History].[Entrepreneur Company ID]
  • Max([Entrepreneur Company Status History].[Entrepreneur Company Status ID])

Where Clause

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

SQL

SELECT [Entrepreneur Company Status History].[Entrepreneur Company ID], Max([Entrepreneur Company Status History].[Entrepreneur Company Status ID]) FROM [SubQry Get Moved Last Week to Active PP Allocated Exited], [Entrepreneur Company Status History] WHERE ((([Entrepreneur Company Status History].[Company Status ID])=2 Or ([Entrepreneu