Skip to content

Query: Qry Get Email Addresses Purple Panelists

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

Tables Referenced

  • Purple Panelists
  • DatabaseUsers

Columns Selected

  • [Purple Panelists].[Purple Panel ID]
  • DatabaseUsers.[Email Address]

Where Clause

((([Purple Panelists].[Purple Panel ID])=[Forms]![Frm Edit Purple Panel Convener

SQL

SELECT [Purple Panelists].[Purple Panel ID], DatabaseUsers.[Email Address] FROM [DatabaseUsers], [Purple Panelists] WHERE ((([Purple Panelists].[Purple Panel ID])=[Forms]![Frm Edit Purple Panel Convener