Skip to content

Query: Qry Qualifications

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

Tables Referenced

  • Positions
  • People
  • Applications
  • Organisational Codes
  • Companies
  • People Qualifications and Certifications
  • Pay Points

Columns Selected

  • Companies.[Company Name]
  • [Organisational Codes].[Organisational Unit]
  • People.[First Name] & \
  • Qualification
  • [People Qualifications and Certifications].[Date Obtained]
  • Institution
  • [People Qualifications and Certifications].[Qualification Cost]
  • Positions.[Position Status ID]
  • [Pay Points].[Pay Point]

SQL

SELECT Companies.[Company Name], [Organisational Codes].[Organisational Unit], People.[First Name] & \, [People Qualifications and Certifications].Qualification, [People Qualifications and Certifications].[Date Obtained], [People Qualifications and Certifications].Institution, [People Qualifications and Certifications].[Qualification Cost], Positions.[Position Status ID], [Pay Points].[Pay Point] FROM [Companies], [Organisational Codes], [Positions], [People], [People Qualifications and Certifications], [Applications], [Pay Points]