Query for a data set



Let us create a query for a data set.

  1. As a data source for the query, select the object (referential) table of the MaterialsAndServices catalog and the virtual table of the Prices.SliceLast information register.

    To avoid ambiguous names in the query, let us change the name of the MaterialsAndServices table.
  2. In the Tables list, right-click MaterialsAndServices, click Rename Table, and type MaterialsAndServicesCat.
Next page: Virtual table parameters