Skip to content

Query: Qry People Qualifications List

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

Tables Referenced

  • People
  • People Qualifications and Certifications

Columns Selected

  • [People Qualifications and Certifications].[People Qualification ID]
  • [People Qualifications and Certifications].[People ID]
  • Qualification
  • [People Qualifications and Certifications].[Date Obtained]
  • Institution
  • [People Qualifications and Certifications].[Qualification Cost]
  • IIf([Own or Company]=1,\
  • [People Qualifications and Certifications].[Expiry Date]

SQL

SELECT [People Qualifications and Certifications].[People Qualification ID], [People Qualifications and Certifications].[People ID], [People Qualifications and Certifications].Qualification, [People Qualifications and Certifications].[Date Obtained], [People Qualifications and Certifications].Institution, [People Qualifications and Certifications].[Qualification Cost], IIf([Own or Company]=1,\, [People Qualifications and Certifications].[Expiry Date] FROM [People Qualifications and Certifications]