Overview  Package   Class  Use  Deprecated  Index  Help 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD

org.jooq
Interface SelectJoinStep

All Superinterfaces:
Adapter, Attachable, FieldLike, FieldProvider, Query, QueryPart, ResultQuery<Record>, Select<Record>, SelectConnectByStep, SelectFinalStep, SelectForUpdateStep, SelectGroupByStep, SelectHavingStep, SelectLimitStep, SelectOrderByStep, SelectWhereStep, java.io.Serializable, TableLike<Record>
All Known Subinterfaces:
SelectFromStep, SelectOnConditionStep, SelectSelectStep
public interface SelectJoinStep
extends SelectWhereStep

This type is used for the Select's DSL API when selecting generic Record types.

Example: 

 -- get all authors' first and last names, and the number
 -- of books they've written in German, if they have written
 -- more than five books in German in the last three years
 -- (from 2011), and sort those authors by last names
 -- limiting results to the second and third row

   SELECT T_AUTHOR.FIRST_NAME, T_AUTHOR.LAST_NAME, COUNT(*)
     FROM T_AUTHOR
     JOIN T_BOOK ON T_AUTHOR.ID = T_BOOK.AUTHOR_ID
    WHERE T_BOOK.LANGUAGE = 'DE'
      AND T_BOOK.PUBLISHED > '2008-01-01'
 GROUP BY T_AUTHOR.FIRST_NAME, T_AUTHOR.LAST_NAME
   HAVING COUNT(*) > 5
 ORDER BY T_AUTHOR.LAST_NAME ASC NULLS FIRST
    LIMIT 2
   OFFSET 1
      FOR UPDATE
       OF FIRST_NAME, LAST_NAME
       NO WAIT
Its equivalent in jOOQ 
 create.select(TAuthor.FIRST_NAME, TAuthor.LAST_NAME, create.count())
       .from(T_AUTHOR)
       .join(T_BOOK).on(TBook.AUTHOR_ID.equal(TAuthor.ID))
       .where(TBook.LANGUAGE.equal("DE"))
       .and(TBook.PUBLISHED.greaterThan(parseDate('2008-01-01')))
       .groupBy(TAuthor.FIRST_NAME, TAuthor.LAST_NAME)
       .having(create.count().greaterThan(5))
       .orderBy(TAuthor.LAST_NAME.asc().nullsFirst())
       .limit(2)
       .offset(1)
       .forUpdate()
       .of(TAuthor.FIRST_NAME, TAuthor.LAST_NAME)
       .noWait();
Refer to the manual for more details

Author:
Lukas Eder

Method Summary
 SelectJoinStep crossJoin(java.lang.String sql)
          CROSS JOIN a table NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
 SelectJoinStep crossJoin(java.lang.String sql, java.lang.Object... bindings)
          CROSS JOIN a table NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
 SelectJoinStep crossJoin(TableLike<?> table)
          CROSS JOIN a table
 SelectOnStep fullOuterJoin(java.lang.String sql)
          FULL OUTER JOIN a table This is only possible where the underlying RDBMS supports it NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
 SelectOnStep fullOuterJoin(java.lang.String sql, java.lang.Object... bindings)
          FULL OUTER JOIN a table This is only possible where the underlying RDBMS supports it NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
 SelectOnStep fullOuterJoin(TableLike<?> table)
          FULL OUTER JOIN a table This is only possible where the underlying RDBMS supports it
 SelectOnStep join(java.lang.String sql)
          INNER JOIN a table NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
 SelectOnStep join(java.lang.String sql, java.lang.Object... bindings)
          INNER JOIN a table NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
 SelectOnStep join(TableLike<?> table)
          INNER JOIN a table
 SelectOnStep leftOuterJoin(java.lang.String sql)
          LEFT OUTER JOIN a table NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
 SelectOnStep leftOuterJoin(java.lang.String sql, java.lang.Object... bindings)
          LEFT OUTER JOIN a table NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
 SelectOnStep leftOuterJoin(TableLike<?> table)
          LEFT OUTER JOIN a table
 SelectJoinStep naturalJoin(java.lang.String sql)
          NATURAL JOIN a table Natural joins are supported by most RDBMS.
 SelectJoinStep naturalJoin(java.lang.String sql, java.lang.Object... bindings)
          NATURAL JOIN a table Natural joins are supported by most RDBMS.
 SelectJoinStep naturalJoin(TableLike<?> table)
          NATURAL JOIN a table Natural joins are supported by most RDBMS.
 SelectJoinStep naturalLeftOuterJoin(java.lang.String sql)
          NATURAL LEFT OUTER JOIN a table Natural joins are supported by most RDBMS.
 SelectJoinStep naturalLeftOuterJoin(java.lang.String sql, java.lang.Object... bindings)
          NATURAL LEFT OUTER JOIN a table Natural joins are supported by most RDBMS.
 SelectJoinStep naturalLeftOuterJoin(TableLike<?> table)
          NATURAL LEFT OUTER JOIN a table Natural joins are supported by most RDBMS.
 SelectJoinStep naturalRightOuterJoin(java.lang.String sql)
          NATURAL RIGHT OUTER JOIN a table and proceed to the next step Natural joins are supported by most RDBMS.
 SelectJoinStep naturalRightOuterJoin(java.lang.String sql, java.lang.Object... bindings)
          NATURAL RIGHT OUTER JOIN a table and proceed to the next step Natural joins are supported by most RDBMS.
 SelectJoinStep naturalRightOuterJoin(TableLike<?> table)
          NATURAL RIGHT OUTER JOIN a table and proceed to the next step Natural joins are supported by most RDBMS.
 SelectOnStep rightOuterJoin(java.lang.String sql)
          RIGHT OUTER JOIN a table This is only possible where the underlying RDBMS supports it NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
 SelectOnStep rightOuterJoin(java.lang.String sql, java.lang.Object... bindings)
          RIGHT OUTER JOIN a table This is only possible where the underlying RDBMS supports it NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
 SelectOnStep rightOuterJoin(TableLike<?> table)
          RIGHT OUTER JOIN a table This is only possible where the underlying RDBMS supports it
 
Methods inherited from interface org.jooq.SelectWhereStep
where, where, where, where, whereExists, whereNotExists
 
Methods inherited from interface org.jooq.SelectConnectByStep
connectBy, connectBy, connectBy, connectByNoCycle, connectByNoCycle, connectByNoCycle
 
Methods inherited from interface org.jooq.SelectGroupByStep
groupBy, groupBy
 
Methods inherited from interface org.jooq.SelectHavingStep
having, having, having, having
 
Methods inherited from interface org.jooq.SelectOrderByStep
orderBy, orderBy, orderBy, orderBy
 
Methods inherited from interface org.jooq.SelectLimitStep
limit, limit
 
Methods inherited from interface org.jooq.SelectForUpdateStep
forShare, forUpdate
 
Methods inherited from interface org.jooq.SelectFinalStep
getQuery
 
Methods inherited from interface org.jooq.Select
except, getSelect, intersect, union, unionAll
 
Methods inherited from interface org.jooq.ResultQuery
bind, bind, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetchAny, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArrays, fetchInto, fetchInto, fetchInto, fetchLater, fetchLater, fetchLazy, fetchMany, fetchMap, fetchMap, fetchMaps, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOneArray, fetchOneMap, getRecordType, getResult
 
Methods inherited from interface org.jooq.Query
execute, getBindValues, getParam, getParams, getSQL
 
Methods inherited from interface org.jooq.Attachable
attach
 
Methods inherited from interface org.jooq.Adapter
internalAPI
 
Methods inherited from interface org.jooq.TableLike
asTable, asTable
 
Methods inherited from interface org.jooq.FieldLike
asField, asField
 
Methods inherited from interface org.jooq.FieldProvider
getField, getField, getField, getFields, getIndex
 

Method Detail

join

SelectOnStep join(TableLike<?> table)
INNER JOIN a table

join

SelectOnStep join(java.lang.String sql)
INNER JOIN a table

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

See Also:
Factory.condition(String)

join

SelectOnStep join(java.lang.String sql,
                  java.lang.Object... bindings)
INNER JOIN a table

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

See Also:
Factory.condition(String, Object...)

crossJoin

SelectJoinStep crossJoin(TableLike<?> table)
CROSS JOIN a table

crossJoin

SelectJoinStep crossJoin(java.lang.String sql)
CROSS JOIN a table

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

See Also:
Factory.condition(String)

crossJoin

SelectJoinStep crossJoin(java.lang.String sql,
                         java.lang.Object... bindings)
CROSS JOIN a table

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

See Also:
Factory.condition(String, Object...)

leftOuterJoin

SelectOnStep leftOuterJoin(TableLike<?> table)
LEFT OUTER JOIN a table

leftOuterJoin

SelectOnStep leftOuterJoin(java.lang.String sql)
LEFT OUTER JOIN a table

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

See Also:
Factory.condition(String)

leftOuterJoin

SelectOnStep leftOuterJoin(java.lang.String sql,
                           java.lang.Object... bindings)
LEFT OUTER JOIN a table

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

See Also:
Factory.condition(String, Object...)

rightOuterJoin

SelectOnStep rightOuterJoin(TableLike<?> table)
RIGHT OUTER JOIN a table

This is only possible where the underlying RDBMS supports it

rightOuterJoin

SelectOnStep rightOuterJoin(java.lang.String sql)
RIGHT OUTER JOIN a table

This is only possible where the underlying RDBMS supports it

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

See Also:
Factory.condition(String)

rightOuterJoin

SelectOnStep rightOuterJoin(java.lang.String sql,
                            java.lang.Object... bindings)
RIGHT OUTER JOIN a table

This is only possible where the underlying RDBMS supports it

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

See Also:
Factory.condition(String, Object...)

fullOuterJoin

SelectOnStep fullOuterJoin(TableLike<?> table)
FULL OUTER JOIN a table

This is only possible where the underlying RDBMS supports it

fullOuterJoin

SelectOnStep fullOuterJoin(java.lang.String sql)
FULL OUTER JOIN a table

This is only possible where the underlying RDBMS supports it

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

See Also:
Factory.condition(String)

fullOuterJoin

SelectOnStep fullOuterJoin(java.lang.String sql,
                           java.lang.Object... bindings)
FULL OUTER JOIN a table

This is only possible where the underlying RDBMS supports it

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

See Also:
Factory.condition(String, Object...)

naturalJoin

SelectJoinStep naturalJoin(TableLike<?> table)
NATURAL JOIN a table

Natural joins are supported by most RDBMS. If they aren't supported, they are simulated if jOOQ has enough information.

naturalJoin

SelectJoinStep naturalJoin(java.lang.String sql)
NATURAL JOIN a table

Natural joins are supported by most RDBMS. If they aren't supported, they are simulated if jOOQ has enough information.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

See Also:
Factory.condition(String)

naturalJoin

SelectJoinStep naturalJoin(java.lang.String sql,
                           java.lang.Object... bindings)
NATURAL JOIN a table

Natural joins are supported by most RDBMS. If they aren't supported, they are simulated if jOOQ has enough information.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

See Also:
Factory.condition(String, Object...)

naturalLeftOuterJoin

SelectJoinStep naturalLeftOuterJoin(TableLike<?> table)
NATURAL LEFT OUTER JOIN a table

Natural joins are supported by most RDBMS. If they aren't supported, they are simulated if jOOQ has enough information.

naturalLeftOuterJoin

SelectJoinStep naturalLeftOuterJoin(java.lang.String sql)
NATURAL LEFT OUTER JOIN a table

Natural joins are supported by most RDBMS. If they aren't supported, they are simulated if jOOQ has enough information.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

See Also:
Factory.condition(String)

naturalLeftOuterJoin

SelectJoinStep naturalLeftOuterJoin(java.lang.String sql,
                                    java.lang.Object... bindings)
NATURAL LEFT OUTER JOIN a table

Natural joins are supported by most RDBMS. If they aren't supported, they are simulated if jOOQ has enough information.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

See Also:
Factory.condition(String, Object...)

naturalRightOuterJoin

SelectJoinStep naturalRightOuterJoin(TableLike<?> table)
NATURAL RIGHT OUTER JOIN a table and proceed to the next step

Natural joins are supported by most RDBMS. If they aren't supported, they are simulated if jOOQ has enough information.

naturalRightOuterJoin

SelectJoinStep naturalRightOuterJoin(java.lang.String sql)
NATURAL RIGHT OUTER JOIN a table and proceed to the next step

Natural joins are supported by most RDBMS. If they aren't supported, they are simulated if jOOQ has enough information.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

See Also:
Factory.condition(String)

naturalRightOuterJoin

SelectJoinStep naturalRightOuterJoin(java.lang.String sql,
                                     java.lang.Object... bindings)
NATURAL RIGHT OUTER JOIN a table and proceed to the next step

Natural joins are supported by most RDBMS. If they aren't supported, they are simulated if jOOQ has enough information.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

See Also:
Factory.condition(String, Object...)
Overview  Package   Class  Use  Deprecated  Index  Help 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD
Copyright © 2011. All Rights Reserved.