Skip to content

Query: Qry Get Purple Panel Convener Name by Purple Panel

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

Tables Referenced

  • Purple Panelists
  • Purple
  • DatabaseUsers

Columns Selected

  • [Purple Panelists].[Purple Panel ID]
  • Convener
  • [First Name] & \

Where Clause

((([Purple Panelists].Convener)=True))

SQL

SELECT [Purple Panelists].[Purple Panel ID], [Purple Panelists].Convener, [First Name] & \ FROM [Purple Panelists], [DatabaseUsers] WHERE ((([Purple Panelists].Convener)=True))