Query: Qry Get People in Positions

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

Tables Referenced

• People
• Job Codes
• Applications
• Positions

Columns Selected

• Positions.[Position ID]
• People.[People ID]
• [First Name] & \
• Job
• Email
• People.[ID Number]
• Positions.[Position Status ID]
• Applications.[Application Status ID]

Where Clause

(((Positions.[Position Status ID])=4) AND ((Applications.[Application Status ID]

Order By

Positions.[Position ID]

SQL

SELECT Positions.[Position ID], People.[People ID], [First Name] & \, [Job Codes].Job, People.Email, People.[ID Number], Positions.[Position Status ID], Applications.[Application Status ID] FROM [People], [Applications], [Positions], [Job Codes] WHERE (((Positions.[Position Status ID])=4) AND ((Applications.[Application Status ID]