Skip to content

Query: Qry Job Codes and Pre Appointment Document Categories List

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

Tables Referenced

  • Job Code Pre Appointment Documents
  • Job
  • Pre Appointment Document Categories
  • Pre Appointment Documents

Columns Selected

  • [Pre Appointment Document Categories].[Sort Order]
  • [Job Code Pre Appointment Documents].[Job ID]
  • [Pre Appointment Documents].[Pre Appointment Document Category ID]
  • [Pre Appointment Document Categories].[Pre Appointment Document Category]

Order By

[Pre Appointment Document Categories].[Sort Order]

SQL

SELECT [Pre Appointment Document Categories].[Sort Order], [Job Code Pre Appointment Documents].[Job ID], [Pre Appointment Documents].[Pre Appointment Document Category ID], [Pre Appointment Document Categories].[Pre Appointment Document Category] FROM [Job Code Pre Appointment Documents], [Pre Appointment Documents], [Pre Appointment Document Categories]