SelectQueryFluentBuilder.Join(String, SqlJoinType, String, String, String, ConditionType) Method
In This Article
Joins two tables. Allows you to specify a table alias, the join operation type, column names by which the tables should be joined, and a relational operation that should be used to compare column values.
Namespace: DevExpress.DataAccess.Sql
Assembly: DevExpress.DataAccess.v24.2.dll
NuGet Package: DevExpress.DataAccess
#Declaration
public SelectQueryFluentBuilder Join(
string tableName,
SqlJoinType joinType,
string tableAlias,
string parentColumnName,
string nestedColumnName,
ConditionType compareOperator
)
#Parameters
Name | Type | Description |
---|---|---|
table |
String | The name of the table (nested table) with which the current table (parent table) of the query builder should be joined. |
join |
Sql |
The join operation type. |
table |
String | A table alias. |
parent |
String | The parent table column name. |
nested |
String | The nested table column name. |
compare |
Condition |
The relational operator type. |
#Returns
Type | Description |
---|---|
Select |
A query builder that contains the join operation result. |
#Example
using DevExpress.DataAccess.Sql;
// ...
var query = SelectQueryFluentBuilder
.AddTable("Categories")
.SelectColumns("CategoryName", "CategoryID")
.Join(tableName: "Products",
tableAlias: "Products1",
joinType: SqlJoinType.Inner,
parentColumnName: "CategoryID",
nestedColumnName: "CtgID",
compareOperator: ConditionType.GreaterOrEqual)
.SelectColumn("ProductName")
.Join(tableName: "Products",
joinType: SqlJoinType.RightOuter,
keyColumnName: "ProductName")
.SelectColumn("UnitPrice")
.Build("Categories");
See Also