Skip to content

Query: Qry Report Active Entrepreneurs by Delivery Location

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

Tables Referenced

  • vwGarnetCountCurrentActiveCompaniesbyDeliveryLocation
  • vwGarnetCountCurrentActiveEntrepreneursbyDeliveryLocation

Columns Selected

  • vwGarnetCountCurrentActiveEntrepreneursbyDeliveryLocation.[Distribution Model]
  • vwGarnetCountCurrentActiveEntrepreneursbyDeliveryLocation.[Delivery Location]
  • vwGarnetCountCurrentActiveEntrepreneursbyDeliveryLocation.[Number Active Entrepr
  • vwGarnetCountCurrentActiveEntrepreneursbyDeliveryLocation.[Companies Target]
  • vwGarnetCountCurrentActiveCompaniesbyDeliveryLocation.[Number Active Companies]

Order By

vwGarnetCountCurrentActiveEntrepreneursbyDeliveryLocation.[Distribution Model], vwGarnetCountCurrentActiveEntrepreneursbyDeliveryLocation.[Delivery Location]

SQL

SELECT vwGarnetCountCurrentActiveEntrepreneursbyDeliveryLocation.[Distribution Model], vwGarnetCountCurrentActiveEntrepreneursbyDeliveryLocation.[Delivery Location], vwGarnetCountCurrentActiveEntrepreneursbyDeliveryLocation.[Number Active Entrepr, vwGarnetCountCurrentActiveEntrepreneursbyDeliveryLocation.[Companies Target], vwGarnetCountCurrentActiveCompaniesbyDeliveryLocation.[Number Active Companies] FROM [vwGarnetCountCurrentActiveEntrepreneursbyDeliveryLocation], [vwGarnetCountCurrentActiveCompaniesbyDeliveryLocation]