Query: Qry MeGRAPH Exception

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

Tables Referenced

• Positions
• People MeGRAPH Scores
• People
• Applications
• Organisational Codes
• Companies

Columns Selected

• Companies.[Company ID]
• Companies.[Company Name]
• [Organisational Codes].[Organisational Unit]
• [People].[First Name] & \
• [People_1].[First Name] & \

Where Clause

(((Companies.[Company ID])=Forms![Frm Reports Company Dialog]![Company ID]) And 

SQL

SELECT Companies.[Company ID], Companies.[Company Name], [Organisational Codes].[Organisational Unit], [People].[First Name] & \, [People_1].[First Name] & \ FROM [People], [People], [People MeGRAPH Scores], [Applications], [Positions], [Companies], [Organisational Codes] WHERE (((Companies.[Company ID])=Forms![Frm Reports Company Dialog]![Company ID]) And