Skip to content

Query: Qry Job Code Pre Appointment Documents

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

Tables Referenced

  • Job Code Pre Appointment Documents
  • Job
  • Pre Appointment Documents

Columns Selected

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

SQL

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