Skip to content

Query: Qry Report Job Code Pre Appointment Documents

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

Tables Referenced

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

Columns Selected

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

SQL

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