Specify the conditions for joining the input event (left side) and the master file (right side).
The format used for join-relational expression is shown below.
Point
Specify the same type on the left and right sides of the join-relational expression.
Note
If the item reference and the function result specified on the left side of the join-relational expression are "null", the join-relational expression is not TRUE even if the item reference and the function result specified on the right side of the join-relational expression are "null".
The join target is only the item within the input event (the input event item joins the master data as a key). Therefore, master data joined by one IF-THEN statement and another master data cannot be joined.
If you want to join a master data item as a key to another master data, describe a join expression in the next IF-THEN statement as shown below, or prepare master data that is already joined and join that.
The joining of two master data can be described using two IF-THEN statements, as follows:
join("MASTER01", $ID == $MemberID) output();
join("MASTER02", $MASTER01.GroupID == $GroupID) output();
See
Refer to "2.4.7 Comparison Operators" for information on the meaning of the comparison operators.
