Skip to content

Query: Qry Get Competent Purple Panelists

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

Tables Referenced

  • DatabaseUsers Module Permissions
  • DatabaseUsers

Columns Selected

  • Username
  • Role
  • [DatabaseUsers Module Permissions].[Module Permission]

Where Clause

((([DatabaseUsers Module Permissions].Role)=\"Guide\") AND (([DatabaseUsers Modu

SQL

SELECT DatabaseUsers.Username, [DatabaseUsers Module Permissions].Role, [DatabaseUsers Module Permissions].[Module Permission] FROM [DatabaseUsers], [DatabaseUsers Module Permissions] WHERE ((([DatabaseUsers Module Permissions].Role)=\"Guide\") AND (([DatabaseUsers Modu