Column Reference Expression

A column-reference expression returns the item stored in the specified column within the context row (the row that a WHERE, ORDER BY, or SELECT clause is currently working on).

A column-reference expression consists of one identifier, or two identifiers separated by a dot. If there are two ids, the first is considered to be a table name or /alias, and the second a column in that table. A single id refers to a column in the table referenced inside the FROM clause.

Notice that child tables in Oracle NoSQL Database have composite names using dot as a separator among multiple ids. As a result, a child-table name cannot be used in a column-reference expression; instead, a table alias must be used to access a child table column using the two-id format. For example, if "Address" is a child table of Persons, then:

SELECT id, p.Address.state FROM Persons p;