Left join of tables

Let us specify the table join.

1. Click the Links tab.
   The platform automatically generates a link condition stating that the value of the MaterialsAndServices dimension of the information register is equal to the reference to the MaterialsAndServices catalog item. It is okay with us.
2. Clear the All check box for the register table and select the All check box for the catalog table.
   
   This is how you specify Left join as the link type for the catalog table (fig. 13.88).
   
   
   Fig. 13.88. Link between the tables in a query
3. On the Conditions tab, specify the criteria for selecting items from the MaterialsAndServices catalog: select only items that have the type passed in the MaterialServiceType parameter (fig. 13.89).
   
   
   Fig. 13.89. Item selection condition

Next page: Field aliases