Sql.Net Class Library Documentation

FromClause.Join Method (JoinType, FromTerm, FromTerm, JoinCondition, JoinCondition, JoinCondition)

Joins two tables using on a triple join condition

public void Join(
   JoinType type,
   FromTerm leftTable,
   FromTerm rightTable,
   JoinCondition cond1,
   JoinCondition cond2,
   JoinCondition cond3
);

Parameters

type
The type of join to be created.
leftTable
The left table
rightTable
The right table
cond1
First equality condition to be applied on the join
cond2
First equality condition to be applied on the join
cond3
First equality condition to be applied on the join

Remarks

A logical AND will be applied on all conditions. Schematically, the resulting SQL will be ... x join y on (cond1 and cond2 and cond3) ...

See Also

FromClause Class | Reeb.SqlOM Namespace | FromClause.Join Overload List