Sql.Net Class Library Documentation

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

Joins two tables using on a single join condition

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

Parameters

type: The type of join to be created.
leftTable: The left table
rightTable: The right table
cond: Equality condition to be applied on the join

Remarks

This overload is used to create the most common type of join, when two tables are joined on a single equality condition.

Example

query.FromClause.Join(JoinType.Inner, tCustomers, tOrders, new JoinCondition("customerId", "customerId"));

See Also

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