Skip to content

Query: Qry Get Raizcorp Possibles Moved Last Week

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

Tables Referenced

  • CompanyStatus
  • SubQry Get Raizcorp Possibles Position
  • Entrepreneur Company Status History

Columns Selected

  • [SubQry Get Raizcorp Possibles Position].[Entrepreneur Company ID]
  • [Entrepreneur Company Status History].[Entrepreneur Company Status ID]
  • [Entrepreneur Company Status History].[Company Status ID]
  • [Entrepreneur Company Status History].[Date Status Changed]
  • Status

Where Clause

((([Entrepreneur Company Status History].[Entrepreneur Company Status ID])>=[Sub

Order By

[SubQry Get Raizcorp Possibles Position].[Entrepreneur Company ID], [Entrepreneur Company Status History].[Entrepreneur Company Status ID]

SQL

SELECT [SubQry Get Raizcorp Possibles Position].[Entrepreneur Company ID], [Entrepreneur Company Status History].[Entrepreneur Company Status ID], [Entrepreneur Company Status History].[Company Status ID], [Entrepreneur Company Status History].[Date Status Changed], CompanyStatus.Status FROM [CompanyStatus], [Entrepreneur Company Status History], [SubQry Get Raizcorp Possibles Position] WHERE ((([Entrepreneur Company Status History].[Entrepreneur Company Status ID])>=[Sub