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 :


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