The link properties describe how the to tables and there columns are linked with each other. A join is made between two tables which will be named "fromTable" and "toTable". You have to define a join type which describes how the tables are linked and a link type which will describe the link between two columns of the joined tables.

Note that you can have multiple links for a join and that the join type will be the same for all links between two columns of the tables.

Defines how the tables should be linked and which data of the tables should be included in the result.

There are four possible values for the join type:

• Inner Join, Includes only the data where the content of the tables is identical
• Left Outer Join, Includes all data from "fromTable" and the data of "toTable" where the content of the linked columns match the link type.
• Right Outer Join, Includes all data from "toTable" and the data of "fromTable" where the content of the linked columns match the link type.
• Full Outer Join, Includes all data from "fromTable" and all data from "toTable".

Defines how the columns of the selected link are linked.

There are six possible values for the join type:

• Equals, All data where the values of the linked columns are be identical will be returned.
• Not Equals, All data where the values of the linked columns are not identical will be returned.
• Greater Equal, All data where the value of the column of "fromTable" is greater or equal than the value of the column of "toTable" will be returned.
• Greater, All data where the value of the column of "fromTable" is greater than the value of the column of "toTable" will be returned.
• Less Equal, All data where the value of the column of "fromTable" is less or equal than the value of the column of "toTable" will be returned.
• Less, All data where the value of the column of "fromTable" is less than the value of the column of "toTable" will be returned.