Query: Qry Get Reporting To Name and Job
Type: Select
Has Parameters: Yes
Has Joins: No
Has Subquery: No
Tables Referenced
- Job
- Positions
- People
- Applications
- Job Codes
Columns Selected
- People.[People ID]
- Applications.[Application Status ID]
- Positions.[Position Status ID]
- Job
- [First Name] & \
Where Clause
(((Applications.[Application Status ID])=27) AND ((Positions.[Position Status ID
SQL
SELECT People.[People ID], Applications.[Application Status ID], Positions.[Position Status ID], [Job Codes].Job, [First Name] & \ FROM [Job Codes], [Positions], [Applications], [People] WHERE (((Applications.[Application Status ID])=27) AND ((Positions.[Position Status ID