Dereferencing Fields

In the simplest case, query language expressions appear as references to fields of infobase tables. References are described by the following rules:

<Field dereferencing>
  |
  [<Table>.]<Field Name>[.<Field Name>[…]]
    |
    <Table Name> | <Source Alias>

Dereferencing of a field begins with the name of the table containing this field. If <Field Name> is unique (i.e. it is only present in one of the tables indicated in the list of sources, the <Table> can be omitted.

If the field has reference type, query language allows you to access table fields that are references, etc. Field names are separated by periods.

If in the Source alias> is assigned to the source table in the list of sources, you can use it instead of table name in dereferencing fields of this table. Otherwise <Table Name> is specified.

See also: Use of Expressions in the Query Language

1C:Enterprise Developer's Community