You are viewing help content for pre-release software. This document and the features it describes are subject to change. Switch to the current version.

SelectQueryFluentBuilder.Join Method

Name Parameters Description
Join(String, RelationColumnInfo[]) tableName, keyColumns Performs an inner join operation with the specified options.
Join(String, SqlJoinType, RelationColumnInfo[]) tableName, joinType, keyColumns Joins two tables. Allows you to specify the join operation type and columns relations by which the tables should be joined.
Join(String, SqlJoinType, String) tableName, joinType, keyColumnName Joins two tables. Allows you to specify the join operation type and a column name by which the tables should be joined.
Join(String, SqlJoinType, String, String) tableName, joinType, parentColumnName, nestedColumnName Joins two tables. Allows you to specify the join operation type and column names by which the tables should be joined.
Join(String, SqlJoinType, String, String, ConditionType) tableName, joinType, parentColumnName, nestedColumnName, compareOperator Joins two tables. Allows you to specify 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.
Join(String, SqlJoinType, String, String, String, ConditionType) tableName, joinType, tableAlias, parentColumnName, nestedColumnName, compareOperator 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.
Join(String, JoinType, RelationColumnInfo[]) tableName, joinType, keyColumns Performs a specified join operation.
Join(String, JoinType, String) tableName, joinType, keyColumnName Performs a specified join operation.
Join(String, JoinType, String, String) tableName, joinType, parentColumnName, nestedColumnName Performs a specified join operation.
Join(String, JoinType, String, String, ConditionType) tableName, joinType, parentColumnName, nestedColumnName, compareOperator Performs a specified join operation.
Join(String, JoinType, String, String, String, ConditionType) tableName, joinType, tableAlias, parentColumnName, nestedColumnName, compareOperator Performs a specified join operation.
Join(String, String) tableName, keyColumnName Performs an inner join operation with the specified options.
Join(String, String, RelationColumnInfo[]) tableName, tableAlias, keyColumns Performs an inner join operation with the specified options.
Join(String, String, SqlJoinType, RelationColumnInfo[]) tableName, tableAlias, joinType, keyColumns Joins two tables. Allows you to specify a table alias, the join operation type, and columns relations by which the tables should be joined.
Join(String, String, SqlJoinType, String) tableName, tableAlias, joinType, keyColumnName Joins two tables. Allows you to specify a table alias, the join operation type, and a column name by which the tables should be joined.
Join(String, String, SqlJoinType, String, String) tableName, tableAlias, joinType, parentColumnName, nestedColumnName Joins two tables. Allows you to specify a table alias, the join operation type, and column names by which the tables should be joined.
Join(String, String, JoinType, RelationColumnInfo[]) tableName, tableAlias, joinType, keyColumns Performs a specified join operation.
Join(String, String, JoinType, String) tableName, tableAlias, joinType, keyColumnName Performs a specified join operation.
Join(String, String, JoinType, String, String) tableName, tableAlias, joinType, parentColumnName, nestedColumnName Performs a specified join operation.
Join(String, String, String) tableName, parentColumnName, nestedColumnName Performs an inner join operation with the specified options.
Join(String, String, String, String) tableName, tableAlias, parentColumnName, nestedColumnName Performs an inner join operation with the specified options.