Nested Queries in the Source List

You can use a nested query as a source table in the list of sources. In this case, the source description contains a description of the nested query. Description of a nested query is composed in the same manner that is used for a regular query.

Using a nested query as a data source is not different from using an infobase table. All the fields described in the selection fields list of the nested query are accessible as fields of such a source.

Example:

Select
   Reference, Nomenclature, Quantity

From
   (
    Select First 8
       Reference, Nomenclature, Quantity

From
       Document.ExpInvoice.Contents
   )
As NestedQuery