Sql.Net Class Library Documentation

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

Joins two tables using on a double join condition

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

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
Second equality condition to be applied on the join

Remarks

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

See Also

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