Field names are written as table.role.field[occurs]. The table name is optional where no ambiguity would arise from its omission. The role must be specified if it is not blank. The occurs may be omitted; in this case the field name is taken as referring to all the occurrences of the field, viewed as a single entity.
For example, a field called ADDRESS with role HOME in table CUSTOMER, having occurs 3, could be referred to as:
CUSTOMER.HOME.ADDRESS
or
HOME.ADDRESS
but not as:
CUSTOMER.ADDRESS
This is true even if HOME is the only possible choice of role. The first line of the address would be CUSTOMER.HOME.ADDRESS[1]. (Note that the ADDRESS field does not have a role in the SALESORD database).
Table or field names may optionally be surrounded by double quotes, for example "<field>". A name so quoted is never read as a reserved word. This provides a method for referring to table or field names which happen to coincide with SQL reserved words (such as DATE or TIME).