Skip to content

Query: Qry Purple Meeting PPP Action List

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

Tables Referenced

  • Purple Meeting Actions
  • Principal Project Pillars
  • Purple
  • Principal Projects
  • Principals

Columns Selected

  • [Purple Meeting Actions].[Purple Meeting Action ID]
  • [Purple Meeting Actions].[Date Created]
  • [Purple Meeting Actions].[Principal Project Pillar ID]
  • Priority
  • Department
  • Action
  • [Purple Meeting Actions].[Due Date]
  • [Purple Meeting Actions].[Date Completed]
  • IIf(IsNull([Project Name]),\
  • [Principal Project Pillars].[BBBEE Pillar]
  • [Principal Projects].[Solutions Architect]
  • Scout

SQL

SELECT [Purple Meeting Actions].[Purple Meeting Action ID], [Purple Meeting Actions].[Date Created], [Purple Meeting Actions].[Principal Project Pillar ID], [Purple Meeting Actions].Priority, [Purple Meeting Actions].Department, [Purple Meeting Actions].Action, [Purple Meeting Actions].[Due Date], [Purple Meeting Actions].[Date Completed], IIf(IsNull([Project Name]),\, [Principal Project Pillars].[BBBEE Pillar], [Principal Projects].[Solutions Architect], [Principal Project Pillars].Scout FROM [Purple Meeting Actions], [Principal Project Pillars], [Principal Projects], [Principals]