Reference - Joints syntax

 

A Joint acts as a Field name and put in relation two tables.

Joints can be used in Field lists (fetch), Where clauses and Sorts.

Each joint has the following format:

Field Name [#] Joint Table [.] Joint Field Name 1 [:] Joint Field Name 2

 

 

Example :

customer_id#customers.id:age

 

In this example, we are querying the table order.

This expression gives the age related to the id found in the table customer, for id equals to customer_id from the table order.

Another way to say is that for the customer_id value from the table order, we are searching the corresponding id in the table customer and get the age value.

 

 

» Reference