Skip to content

Query: Qry Report Entrepreneurial Profiles

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

Tables Referenced

  • SubQry Rpt Entrepreneurial Profiles
  • CompanyStatus
  • Principal Projects
  • Entrepreneur Profile Presented To
  • Entrepreneur Company
  • Principals
  • Entrepreneurs

Columns Selected

  • Entrepreneurs.[Process Status ID]
  • [First Name] & \
  • Status
  • Entrepreneurs.[Date Panel Held]
  • [Principal] & \
  • [Entrepreneur Profile Presented To].[Solutions Architect]
  • [Entrepreneur Profile Presented To].[Date Presented]
  • [Entrepreneur Profile Presented To].[Result Date]
  • Result

Where Clause

(((Entrepreneurs.[Process Status ID])=91))

SQL

SELECT Entrepreneurs.[Process Status ID], [First Name] & \, CompanyStatus.Status, Entrepreneurs.[Date Panel Held], [Principal] & \, [Entrepreneur Profile Presented To].[Solutions Architect], [Entrepreneur Profile Presented To].[Date Presented], [Entrepreneur Profile Presented To].[Result Date], [Entrepreneur Profile Presented To].Result FROM [Entrepreneurs], [Entrepreneur Profile Presented To], [Principal Projects], [Principals], [SubQry Rpt Entrepreneurial Profiles], [Entrepreneur Company], [CompanyStatus] WHERE (((Entrepreneurs.[Process Status ID])=91))