Skip to content

Query: SubQry Get EP Ready for Allocation Info by Company

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

Tables Referenced

  • Entrepreneur Company
  • Entrepreneurs
  • Entrepreneur Company Programme Years

Columns Selected

  • Entrepreneurs.[Entrepreneur Company ID]

Where Clause

(((Entrepreneurs.[Process Status ID])=91)) OR ((([Entrepreneur Company Programme

Order By

Entrepreneurs.[Entrepreneur Company ID]

SQL

SELECT Entrepreneurs.[Entrepreneur Company ID] FROM [Entrepreneurs], [Entrepreneur Company], [Entrepreneur Company Programme Years] WHERE (((Entrepreneurs.[Process Status ID])=91)) OR ((([Entrepreneur Company Programme