Skip to main content

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, 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, 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) 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, JoinType, RelationColumnInfo[]) tableName, joinType, keyColumns Obsolete. Performs a specified join operation.
Join(String, JoinType, String, String, ConditionType) tableName, joinType, parentColumnName, nestedColumnName, compareOperator Obsolete. Performs a specified join operation.
Join(String, JoinType, String, String, String, ConditionType) tableName, joinType, tableAlias, parentColumnName, nestedColumnName, compareOperator Obsolete. Performs a specified join operation.
Join(String, JoinType, String, String) tableName, joinType, parentColumnName, nestedColumnName Obsolete. Performs a specified join operation.
Join(String, JoinType, String) tableName, joinType, keyColumnName Obsolete. Performs a specified join operation.
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, 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, 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, JoinType, RelationColumnInfo[]) tableName, tableAlias, joinType, keyColumns Obsolete. Performs a specified join operation.
Join(String, String, JoinType, String, String) tableName, tableAlias, joinType, parentColumnName, nestedColumnName Obsolete. Performs a specified join operation.
Join(String, String, JoinType, String) tableName, tableAlias, joinType, keyColumnName Obsolete. Performs a specified join operation.
Join(String, String, String, String) tableName, tableAlias, parentColumnName, nestedColumnName Performs an inner join operation with the specified options.
Join(String, String, String) tableName, parentColumnName, nestedColumnName Performs an inner join operation with the specified options.
Join(String, String) tableName, keyColumnName Performs an inner join operation with the specified options.