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.
