Joins two tables using on an arbitrary join condition
Use this overload to create complex join conditions. Note that not all WhereClause operators and expressions are supported in joins.
WhereClause condition = new WhereClause(WhereClauseRelationship.Or); condition.Terms.Add(WhereTerm.CreateCompare(SqlExpression.Field("productId", tOrders), SqlExpression.Field("productId", tProducts), CompareOperator.Equal)); condition.Terms.Add(WhereTerm.CreateCompare(SqlExpression.Field("productName", tOrders), SqlExpression.Field("productName", tProducts), CompareOperator.Equal)); query.FromClause.Join(JoinType.Left, tOrders, tProducts, condition);
FromClause Class | Reeb.SqlOM Namespace | FromClause.Join Overload List