Skip to content

Query: Qry Get Delivery Locations for Bookkeeping Compliance Report

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

Tables Referenced

  • Delivery Locations
  • Entrepreneur Company
  • Delivery
  • DatabaseUsers
  • Submissions

Columns Selected

  • [Delivery Locations].[Delivery Location ID]
  • [Delivery Locations].[Delivery Location]
  • DatabaseUsers.[Email Address]

SQL

SELECT [Delivery Locations].[Delivery Location ID], [Delivery Locations].[Delivery Location], DatabaseUsers.[Email Address] FROM [Delivery Locations], [DatabaseUsers], [Entrepreneur Company], [Submissions]