Package com.github.eikecochu.sqlbuilder

Interface BeforeJoin<T extends BeforeJoin<T>>

Type Parameters:

T - the generic type returned by some fluent methods of this interface

All Superinterfaces:

QueryPart, QueryPartLinked<T>, QueryPartSQL<T>

All Known Implementing Classes:

From, Join

public interface BeforeJoin<T extends BeforeJoin<T>>
extends QueryPart, QueryPartSQL<T>, QueryPartLinked<T>

Implemented by keywords that precede the JOIN statement.

Method Summary

Modifier and Type	Method	Description
default Join	crossJoin()	Continue query with CROSS JOIN
default Join	crossJoin(Table table)	Continue query with CROSS JOIN
default Join	crossJoin(java.lang.String table)	Continue query with CROSS JOIN
default Join	fullOuterJoin()	Continue query with FULL OUTER JOIN
default Join	fullOuterJoin(Table table)	Continue query with FULL OUTER JOIN
default Join	fullOuterJoin(java.lang.String table)	Continue query with FULL OUTER JOIN
default Join	innerJoin()	Continue query with INNER JOIN
default Join	innerJoin(Table table)	Continue query with INNER JOIN
default Join	innerJoin(java.lang.String table)	Continue query with INNER JOIN
default Join	innerJoinOnColsEq(Table table, java.lang.String col1, java.lang.String col2)	Continue query with INNER JOIN and use two columns as condition with col1 = col2
default Join	innerJoinOnColsEq(java.lang.String table, java.lang.String col1, java.lang.String col2)	Continue query with INNER JOIN and use two columns as condition with col1 = col2
default Join	join()	Continue query with INNER JOIN
default Join	join(Join join)	Accept an existing JOIN statement as predecessor
default Join	join(JoinMode mode)	Continue query with the passed JOIN mode
default Join	join(Table table)	Continue query with JOIN
default Join	join(java.lang.String table)	Continue query with JOIN
default Join	joinSQL(java.lang.String sql)	Use plain SQL to form this JOIN statement
default Join	leftJoin()	Continue query with LEFT JOIN
default Join	leftJoin(Table table)	Continue query with LEFT JOIN
default Join	leftJoin(java.lang.String table)	Continue query with LEFT JOIN
default Join	leftOuterJoin()	Continue query with LEFT OUTER JOIN
default Join	leftOuterJoin(Table table)	Continue query with LEFT OUTER JOIN
default Join	leftOuterJoin(java.lang.String table)	Continue query with LEFT OUTER JOIN
default Join	outerJoin()	Continue query with OUTER JOIN
default Join	outerJoin(Table table)	Continue query with OUTER JOIN
default Join	outerJoin(java.lang.String table)	Continue query with OUTER JOIN
default Join	rightJoin()	Continue query with RIGHT JOIN
default Join	rightJoin(Table table)	Continue query with RIGHT JOIN
default Join	rightJoin(java.lang.String table)	Continue query with RIGHT JOIN
default Join	rightOuterJoin()	Continue query with RIGHT OUTER JOIN
default Join	rightOuterJoin(Table table)	Continue query with RIGHT OUTER JOIN
default Join	rightOuterJoin(java.lang.String table)	Continue query with RIGHT OUTER JOIN

Methods inherited from interface com.github.eikecochu.sqlbuilder.QueryPart

string, string

Methods inherited from interface com.github.eikecochu.sqlbuilder.QueryPartLinked

ext, parent, parent

Methods inherited from interface com.github.eikecochu.sqlbuilder.QueryPartSQL

sql

Method Detail

join

default Join join(JoinMode mode)

Continue query with the passed JOIN mode

Parameters:

mode - The JOIN mode to use

Returns:

The new JOIN statement

join

default Join join()

Continue query with INNER JOIN

Returns:

The new INNER JOIN statement

join

default Join join(java.lang.String table)

Continue query with JOIN

Parameters:

table - The name of the table to join to

Returns:

The new JOIN statement

join

default Join join(Table table)

Continue query with JOIN

Parameters:

table - The Table representation of the table to join to

Returns:

The new JOIN statement

join

default Join join(Join join)

Accept an existing JOIN statement as predecessor

Parameters:

join - The existing JOIN statement

Returns:

Returns the passed JOIN statement

joinSQL

default Join joinSQL(java.lang.String sql)

Use plain SQL to form this JOIN statement

Parameters:

sql - The sql string

Returns:

The new JOIN statement

innerJoin

default Join innerJoin()

Continue query with INNER JOIN

Returns:

The new INNER JOIN statement

innerJoin

default Join innerJoin(java.lang.String table)

Continue query with INNER JOIN

Parameters:

table - The name of the table to join to

Returns:

The new INNER JOIN statement

innerJoin

default Join innerJoin(Table table)

Continue query with INNER JOIN

Parameters:

table - The Table representation of the table to join to

Returns:

The new INNER JOIN statement

innerJoinOnColsEq

default Join innerJoinOnColsEq(java.lang.String table,
                               java.lang.String col1,
                               java.lang.String col2)

Continue query with INNER JOIN and use two columns as condition with col1 = col2

Parameters:

table - The name of the table to join to

col1 - The first column

col2 - The second column, equal to col1

Returns:

The new INNER JOIN statement

innerJoinOnColsEq

default Join innerJoinOnColsEq(Table table,
                               java.lang.String col1,
                               java.lang.String col2)

Continue query with INNER JOIN and use two columns as condition with col1 = col2

Parameters:

table - The Table representation of the table to join to

col1 - The first column

col2 - The second column, equal to col1

Returns:

The new INNER JOIN statement

crossJoin

default Join crossJoin()

Continue query with CROSS JOIN

Returns:

The new CROSS JOIN statement

crossJoin

default Join crossJoin(java.lang.String table)

Continue query with CROSS JOIN

Parameters:

table - The name of the table to join to

Returns:

The new CROSS JOIN statement

crossJoin

default Join crossJoin(Table table)

Continue query with CROSS JOIN

Parameters:

table - The Table representation of the table to join to

Returns:

The new CROSS JOIN statement

outerJoin

default Join outerJoin()

Continue query with OUTER JOIN

Returns:

The new OUTER JOIN statement

outerJoin

default Join outerJoin(java.lang.String table)

Continue query with OUTER JOIN

Parameters:

table - The name of the table to join to

Returns:

The new OUTER JOIN statement

outerJoin

default Join outerJoin(Table table)

Continue query with OUTER JOIN

Parameters:

table - The Table representation of the table to join to

Returns:

The new OUTER JOIN statement

fullOuterJoin

default Join fullOuterJoin()

Continue query with FULL OUTER JOIN

Returns:

The new FULL OUTER JOIN statement

fullOuterJoin

default Join fullOuterJoin(java.lang.String table)

Continue query with FULL OUTER JOIN

Parameters:

table - The name of the table to join to

Returns:

The new FULL OUTER JOIN statement

fullOuterJoin

default Join fullOuterJoin(Table table)

Continue query with FULL OUTER JOIN

Parameters:

table - The Table representation of the table to join to

Returns:

The new FULL OUTER JOIN statement

leftJoin

default Join leftJoin()

Continue query with LEFT JOIN

Returns:

The new LEFT JOIN statement

leftJoin

default Join leftJoin(java.lang.String table)

Continue query with LEFT JOIN

Parameters:

table - The name of the table to join to

Returns:

The new LEFT JOIN statement

leftJoin

default Join leftJoin(Table table)

Continue query with LEFT JOIN

Parameters:

table - The Table representation of the table to join to

Returns:

The new LEFT JOIN statement

leftOuterJoin

default Join leftOuterJoin()

Continue query with LEFT OUTER JOIN

Returns:

The new LEFT OUTER JOIN statement

leftOuterJoin

default Join leftOuterJoin(java.lang.String table)

Continue query with LEFT OUTER JOIN

Parameters:

table - The name of the table to join to

Returns:

The new LEFT OUTER JOIN statement

leftOuterJoin

default Join leftOuterJoin(Table table)

Continue query with LEFT OUTER JOIN

Parameters:

table - The Table representation of the table to join to

Returns:

The new LEFT OUTER JOIN statement

rightJoin

default Join rightJoin()

Continue query with RIGHT JOIN

Returns:

The new RIGHT JOIN statement

rightJoin

default Join rightJoin(java.lang.String table)

Continue query with RIGHT JOIN

Parameters:

table - The name of the table to join to

Returns:

The new RIGHT JOIN statement

rightJoin

default Join rightJoin(Table table)

Continue query with RIGHT JOIN

Parameters:

table - The Table representation of the table to join to

Returns:

The new RIGHT JOIN statement

rightOuterJoin

default Join rightOuterJoin()

Continue query with RIGHT OUTER JOIN

Returns:

The new RIGHT OUTER JOIN statement

rightOuterJoin

default Join rightOuterJoin(java.lang.String table)

Continue query with RIGHT OUTER JOIN

Parameters:

table - The name of the table to join to

Returns:

The new RIGHT OUTER JOIN statement

rightOuterJoin

default Join rightOuterJoin(Table table)

Continue query with RIGHT OUTER JOIN

Parameters:

table - The Table representation of the table to join to

Returns:

The new RIGHT OUTER JOIN statement