/** * Construct a CROSS join with an ON clause. A CROSS join produces the same result as an INNER join, but prohibits * the query optimizer from reordering the tables in the join. Avoid using CROSS join except in specific situations * where manual control of the query optimizer is desired. * * @param table the table to join on * @param criterions criterions to use for the ON clause */ public static Join cross(SqlTable<?> table, Criterion... criterions) { return new Join(table, JoinType.CROSS, criterions); }
/** * Construct a LEFT join with an ON clause. Left joins return all the rows an INNER join would return, plus an * extra row for each row in the left-hand dataset that corresponds to no rows at all in the composite dataset (if * any). The added rows contain NULL values in the columns from the right-hand dataset. * * @param table the table to join on * @param criterions criterions to use for the ON clause */ public static Join left(SqlTable<?> table, Criterion... criterions) { return new Join(table, JoinType.LEFT, criterions); }
/** * Construct an INNER join with a USING clause. * * @param table the table to join on * @param usingColumns columns to use for the USING clause */ public static Join inner(SqlTable<?> table, Property<?>... usingColumns) { return new Join(table, JoinType.INNER, usingColumns); }
/** * Construct a LEFT join with a USING clause. Left joins return all the rows an INNER join would return, plus an * extra row for each row in the left-hand dataset that corresponds to no rows at all in the composite dataset (if * any). The added rows contain NULL values in the columns from the right-hand dataset. * * @param table the table to join on * @param usingColumns columns to use for the USING clause */ public static Join left(SqlTable<?> table, Property<?>... usingColumns) { return new Join(table, JoinType.LEFT, usingColumns); }
/** * Construct an INNER join with an ON clause. * * @param table the table to join on * @param criterions criterions to use for the ON clause */ public static Join inner(SqlTable<?> table, Criterion... criterions) { return new Join(table, JoinType.INNER, criterions); }
/** * Construct a CROSS join with a USING clause. A CROSS join produces the same result as an INNER join, but * prohibits the query optimizer from reordering the tables in the join. Avoid using CROSS join except in specific * situations where manual control of the query optimizer is desired. * * @param table the table to join on * @param usingColumns columns to use for the USING clause */ public static Join cross(SqlTable<?> table, Property<?>... usingColumns) { return new Join(table, JoinType.CROSS, usingColumns); }
/** * Construct a CROSS join with an ON clause. A CROSS join produces the same result as an INNER join, but prohibits * the query optimizer from reordering the tables in the join. Avoid using CROSS join except in specific situations * where manual control of the query optimizer is desired. * * @param table the table to join on * @param criterions criterions to use for the ON clause */ public static Join cross(SqlTable<?> table, Criterion... criterions) { return new Join(table, JoinType.CROSS, criterions); }
/** * Construct a LEFT join with an ON clause. Left joins return all the rows an INNER join would return, plus an * extra row for each row in the left-hand dataset that corresponds to no rows at all in the composite dataset (if * any). The added rows contain NULL values in the columns from the right-hand dataset. * * @param table the table to join on * @param criterions criterions to use for the ON clause */ public static Join left(SqlTable<?> table, Criterion... criterions) { return new Join(table, JoinType.LEFT, criterions); }
/** * Construct an INNER join with a USING clause. * * @param table the table to join on * @param usingColumns columns to use for the USING clause */ public static Join inner(SqlTable<?> table, Property<?>... usingColumns) { return new Join(table, JoinType.INNER, usingColumns); }
/** * Construct an INNER join with an ON clause. * * @param table the table to join on * @param criterions criterions to use for the ON clause */ public static Join inner(SqlTable<?> table, Criterion... criterions) { return new Join(table, JoinType.INNER, criterions); }
/** * Construct a LEFT join with a USING clause. Left joins return all the rows an INNER join would return, plus an * extra row for each row in the left-hand dataset that corresponds to no rows at all in the composite dataset (if * any). The added rows contain NULL values in the columns from the right-hand dataset. * * @param table the table to join on * @param usingColumns columns to use for the USING clause */ public static Join left(SqlTable<?> table, Property<?>... usingColumns) { return new Join(table, JoinType.LEFT, usingColumns); }
/** * Construct a CROSS join with a USING clause. A CROSS join produces the same result as an INNER join, but * prohibits the query optimizer from reordering the tables in the join. Avoid using CROSS join except in specific * situations where manual control of the query optimizer is desired. * * @param table the table to join on * @param usingColumns columns to use for the USING clause */ public static Join cross(SqlTable<?> table, Property<?>... usingColumns) { return new Join(table, JoinType.CROSS, usingColumns); }