Skip to content

Query: JB SubQry Get Ready For Allocation without History

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

Tables Referenced

  • Entrepreneur Status History
  • Entrepreneur

Columns Selected

  • [Entrepreneur Status History].[Entrepreneur ID]

Where Clause

((([Entrepreneur Status History].[Process Status ID])<>91))

SQL

SELECT [Entrepreneur Status History].[Entrepreneur ID] FROM [Entrepreneur Status History] WHERE ((([Entrepreneur Status History].[Process Status ID])<>91))