QuerySourceBase<TSource>.Join Method (QuerySourceTable, String, String, IWhereCondition, JoinTypeEnum)

Joins the given source with another

Namespace: CMS.DataEngine
Assembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 12.0.0

Syntax

public TSource Join(
	QuerySourceTable source,
	string leftColumn,
	string rightColumn,
	IWhereCondition additionalCondition = null,
	JoinTypeEnum joinType = JoinTypeEnum.Inner
)

Parameters

source

Type: CMS.DataEngine.QuerySourceTable
Source table

leftColumn

Type: System.String
Left column

rightColumn

Type: System.String
Right column

additionalCondition (Optional)

Type: CMS.DataEngine.IWhereCondition
Additional JOIN condition, this will be added with AND operator to the base condition

joinType (Optional)

Type: CMS.DataEngine.JoinTypeEnum
Type of the join

Return Value

Type: TSource