Sql.Net Class Library Documentation

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

Joins two tables using on an array join condition

public void Join(
   JoinType type,
   FromTerm leftTable,
   FromTerm rightTable,
   JoinCondition[] conditions
);

Parameters

type
The type of join to be created.
leftTable
The left table
rightTable
The right table
conditions
An array of equality condition to be applied on the join

Remarks

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

See Also

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