Skip to content

Raizcorp Technical Documentation

Query: Qry Count Current Part Sponsorship by Delivery Location

Query: Qry Count Current Part Sponsorship by Delivery Location

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

Tables Referenced

Delivery
Qry Report Part Sponsorship
Delivery Locations

Columns Selected

[Qry Report Part Sponsorship].[Company Delivery Location ID]
[Delivery Locations].[Delivery Location]
Count([Qry Report Part Sponsorship].[Entrepreneur Company ID])
Sum([Qry Report Part Sponsorship].[Amount Needed])

Order By

[Delivery Locations].[Delivery Location]

SQL

SELECT [Qry Report Part Sponsorship].[Company Delivery Location ID], [Delivery Locations].[Delivery Location], Count([Qry Report Part Sponsorship].[Entrepreneur Company ID]), Sum([Qry Report Part Sponsorship].[Amount Needed]) FROM [Delivery Locations], [Qry Report Part Sponsorship]