Skip to content

Query: Qry Proposal Delivery Regions List

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

Tables Referenced

  • Delivery Locations Sales
  • Proposal
  • Divisions Proposal
  • Proposal Delivery Regions
  • Distribution Models Proposal

Columns Selected

  • [Proposal Delivery Regions].[Delivery Region ID]
  • [Proposal Delivery Regions].[Proposal ID]
  • Division
  • [Distribution Models Proposal].[Distribution Model]
  • IIf([Existing or New]=1,\
  • IIf([Existing or New]=1,[Delivery Location],[New Delivery Location])
  • [Proposal Delivery Regions].[Geographic Area]
  • [Distribution Models Proposal].[Distribution Model ID]

SQL

SELECT [Proposal Delivery Regions].[Delivery Region ID], [Proposal Delivery Regions].[Proposal ID], [Divisions Proposal].Division, [Distribution Models Proposal].[Distribution Model], IIf([Existing or New]=1,\, IIf([Existing or New]=1,[Delivery Location],[New Delivery Location]), [Proposal Delivery Regions].[Geographic Area], [Distribution Models Proposal].[Distribution Model ID] FROM [Proposal Delivery Regions], [Distribution Models Proposal], [Divisions Proposal], [Delivery Locations Sales]