A Join object contains the properties for a relation in the data dictionary. This object has no methods.

Properties

Name	Data Type	Description
ChildExpression	Character	The aliased field name of the child field for the join. This is used for simple expressions and is empty if JoinExpression if filled in.
ChildTable	Character	The name of the child table in the relationship.
JoinExpression	Character	The join expression for the relation. This is used for complex expressions and is empty if ChildExpression and ParentExpression are filled in.
JoinName	Character	The name of the join. In Stonefield Query, the name is usually the parent table name and the child table name separated by a comma (that is, PARENT,CHILD).
JoinType	Numeric	The join type: 0: inner join 1: left outer join 2: right outer join 3: full join
ParentExpression	Character	The aliased field name of the parent field for the join. This is used for simple expressions and is empty if JoinExpression if filled in.
ParentTable	Character	The name of the parent table in the relationship.
Weight	Numeric	The weighting for the join.

See Also
Joins Collection | Relation Properties