Query: Qry ISP Exception
Type: Select
Has Parameters: Yes
Has Joins: No
Has Subquery: No
Tables Referenced
- Companies
- Positions
- People
- Applications
- Job Codes
- People Three Plus One
- Organisational Codes
Columns Selected
- Companies.[Company Name]
- [Organisational Codes].[Organisational Unit]
- [People].[First Name] & \
- Job
- [People_1].[First Name] & \
Order By
[People_1].[First Name] & \
SQL
SELECT Companies.[Company Name], [Organisational Codes].[Organisational Unit], [People].[First Name] & \, [Job Codes].Job, [People_1].[First Name] & \ FROM [People], [Organisational Codes], [People], [People Three Plus One], [Applications], [Positions], [Companies], [Job Codes]