Skip to content

Query: Qry Get Email Address COO

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

Tables Referenced

  • DatabaseUsers Module Permissions
  • DatabaseUsers

Columns Selected

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

Where Clause

(((DatabaseUsers.[Email Address]) Is Not Null) AND (([DatabaseUsers Module Permi

SQL

SELECT DatabaseUsers.Username, DatabaseUsers.[Email Address], [DatabaseUsers Module Permissions].[Module Permission], [DatabaseUsers Module Permissions].Role FROM [DatabaseUsers], [DatabaseUsers Module Permissions] WHERE (((DatabaseUsers.[Email Address]) Is Not Null) AND (([DatabaseUsers Module Permi