Skip to content

Query: Qry Get Sales Brief Marketing Sourced From

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

Tables Referenced

  • Sales Brief Selection Marketing Sourced From
  • Sales
  • Delivery Locations Sales

Columns Selected

  • [Sales Brief Selection Marketing Sourced From].[Sales Brief Selection Marketing
  • [Sales Brief Selection Marketing Sourced From].[Delivery Location ID]
  • [Delivery Locations Sales].[Delivery Location]
  • [Sales Brief Selection Marketing Sourced From].[Delivery Location Other]

SQL

SELECT [Sales Brief Selection Marketing Sourced From].[Sales Brief Selection Marketing , [Sales Brief Selection Marketing Sourced From].[Delivery Location ID], [Delivery Locations Sales].[Delivery Location], [Sales Brief Selection Marketing Sourced From].[Delivery Location Other] FROM [Sales Brief Selection Marketing Sourced From], [Delivery Locations Sales]