Query: Qry Get Emerald Users

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

Tables Referenced

• DatabaseUsers Module Permissions
• DatabaseUsers

Columns Selected

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

Where Clause

((([DatabaseUsers Module Permissions].[Module Permission])=\"Emerald\"))

SQL

SELECT DatabaseUsers.Username, DatabaseUsers.[Email Address], DatabaseUsers.Department, [DatabaseUsers Module Permissions].[Module Permission], [DatabaseUsers Module Permissions].LEVEL, [DatabaseUsers Module Permissions].Role FROM [DatabaseUsers], [DatabaseUsers Module Permissions] WHERE ((([DatabaseUsers Module Permissions].[Module Permission])=\"Emerald\"))