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