Skip to content

Query: SubQry Get Entrepreneurs Mod OwnedBy Date Range Crit

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

Tables Referenced

  • Entrepreneur Status History
  • ProcessStatus
  • Entrepreneurs

Columns Selected

  • Entrepreneurs.[Entrepreneur ID]

Where Clause

(((Entrepreneurs.[Pipeline ID])=1) And ((Entrepreneurs.OwnedBy) Is Not Null) And

SQL

SELECT Entrepreneurs.[Entrepreneur ID] FROM [Entrepreneurs], [Entrepreneur Status History], [ProcessStatus] WHERE (((Entrepreneurs.[Pipeline ID])=1) And ((Entrepreneurs.OwnedBy) Is Not Null) And