Analyzing query text

Let us analyze the generated query text (listing 13.13).

Listing 13.13. Query text

SELECT
    MaterialsAndServices.Parent AS ServiceGroup,
    MaterialsAndServicesCat.Ref AS Service,
    PricesSliceLast.Price
FROM
    Catalog.MaterialsAndServices AS MaterialsAndServicesCat
        LEFT JOIN InformationRegister.Prices.SliceLast(&ReportDate, ) AS PricesSliceLast
        ON (PricesSliceLast.MaterialOrService = MaterialsAndServicesCat.Ref)
WHERE
    MaterialsAndServicesCat.MaterialServiceType = &MaterialServiceType

Almost all of the clauses used in this query are already familiar to you. Let us proceed to editing the data composition schema.

Next page: Resources