Skip to content

Query: Qry Entrepreneur List Purple Meeting

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

Tables Referenced

  • Principal Projects
  • Temp
  • Temp Purple Meeting Status
  • Principals

Columns Selected

  • [Principal] & \
  • [Temp Purple Meeting Status].[Step 2]
  • [Temp Purple Meeting Status].[Step 3]
  • [Temp Purple Meeting Status].[Step 4]
  • [Temp Purple Meeting Status].[Step 5]
  • [Temp Purple Meeting Status].[Step 6]
  • [Temp Purple Meeting Status].[Step 7]
  • [Temp Purple Meeting Status].[Not Allocated (Companies)]
  • [Temp Purple Meeting Status].[Allocated (Companies)]
  • [Temp Purple Meeting Status].[Step 8 (Ready for Allocation)]

Order By

[Principal] & \

SQL

SELECT [Principal] & \, [Temp Purple Meeting Status].[Step 2], [Temp Purple Meeting Status].[Step 3], [Temp Purple Meeting Status].[Step 4], [Temp Purple Meeting Status].[Step 5], [Temp Purple Meeting Status].[Step 6], [Temp Purple Meeting Status].[Step 7], [Temp Purple Meeting Status].[Not Allocated (Companies)], [Temp Purple Meeting Status].[Allocated (Companies)], [Temp Purple Meeting Status].[Step 8 (Ready for Allocation)] FROM [Temp Purple Meeting Status], [Principal Projects], [Principals]