Sql.Net Class Library Documentation

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

Joins two tables using on a single join condition

public void Join(
   JoinType type,
   FromTerm leftTable,
   FromTerm rightTable,
   string leftField,
   string rightField
);

Parameters

type: The type of join to be created.
leftTable: The left table
rightTable: The right table
leftField: Name of the field in the left table to join on
rightField: Name of the field in the right table to join on

Example

query.FromClause.Join(JoinType.Left, tCustomers, tOrders, "customerId", "customerId");

See Also

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