RWDBJoinExpr

RWDBJoinExpr  RWDBExpr

• Data Type and Member Function Indexes
• Synopsis
• Description
• Example
• Related Classes
• Public Constructors
• Public Member Operator
• Public Member Functions
• Related Global Functions

Member Functions
operator=() rwdbLeftOuter()	rwdbNaturalLeftOuter() rwdbNaturalOuter()	rwdbNaturalRightOuter() rwdbOuter()	rwdbRightOuter()

#include <rw/db/expr.h>

RWDBJoinExpr is created by a set of global functions that generate ANSI SQL outer join syntax. It represents a specialized type of RWDBExpr that is used only for building outer join constructs.

In this example, an RWDBJoinExpr is created anonymously by the related global function rwdbOuter, and set as part of the from clause.

RWDBTable t1 = aDatabase.table("tabel1");
RWDBTable t2 = aDatabase.table("table2");

RWDBSelector aSelector = aDB.selector();
aSelector.from( rwdbOuter(t1, t2) );

RWDBJoinExpr is a special case of RWDBExpr. See RWDBExpr for more details. Also see RWDBColumn.

RWDBJoinExpr();

The default constructor is provided for convenience. Typically, RWDBJoinExpr instances are obtained through outer join global functions.

RWDBJoinExpr(const RWDBJoinExpr& jexpr);

Copy constructor. The created RWDBJoinExpr shares an implementation with jexpr.

RWDBJoinExpr(const RWDBExpr& expr1, const RWDBExpr& expr2,
             RWDBPhraseBook::RWDBPhraseKey op,
             RWDBPhraseBook::RWDBPhraseKey precdBegin = 
                 RWDBPhraseBook::singleSpace,
             RWDBPhraseBook::RWDBPhraseKey precdEnd = 
                 RWDBPhraseBook::singleSpace);

Constructs an RWDBJoinExpr from two expressions. The constructed RWDBJoinExpr represents an encapsulation of the SQL phrase:

'expr1' op 'expr2'.

RWDBJoinExpr&
operator=(const RWDBJoinExpr& jexpr);

Assignment operator. Self shares an implementation with jexpr. Returns a reference to self.

See RWDBExpr for details.

RWDBJoinExpr
rwdbLeftOuter(const RWDBTable& table1, 
              const RWDBTable& table2);

Returns an RWDBJoinExpr that represents an encapsulation of the LEFT OUTER JOIN SQL phrase between two tables.

RWDBJoinExpr
rwdbLeftOuter(const RWDBTable& table, 
              const RWDBJoinExpr& jexpr);

Returns an RWDBJoinExpr that represents an encapsulation of the LEFT OUTER JOIN SQL phrase between a table and an outer join expression. For databases that support precedence in outer joins, the generated SQL adds precedence to jexpr such that jexpr is evaluated first before the table is joined.

RWDBJoinExpr
rwdbLeftOuter(const RWDBJoinExpr& jexpr, 
              const RWDBTable& table);

Returns an RWDBJoinExpr that represents an encapsulation of the LEFT OUTER JOIN SQL phrase between an outer join expression and a table. This does not add any precedence to the constructs.

RWDBJoinExpr
rwdbLeftOuter(const RWDBJoinExpr& jexpr1, 
              const RWDBJoinExpr& jexpr2);

Returns an RWDBJoinExpr that represents an encapsulation of the LEFT OUTER JOIN SQL phrase between two outer join expressions. This does not add any precedence to the constructs.

RWDBJoinExpr
rwdbRightOuter(const RWDBTable& table1, 
               const RWDBTable& table2);

Returns an RWDBJoinExpr that represents an encapsulation of the RIGHT OUTER JOIN SQL phrase between two tables.

RWDBJoinExpr
rwdbRightOuter(const RWDBTable& table, 
               const RWDBJoinExpr& jexpr);

Returns an RWDBJoinExpr that represents an encapsulation of the RIGHT OUTER JOIN SQL phrase between a table and an outer join expression. For databases that support precedence in outer joins, the generated SQL adds precedence to jexpr, such that jexpr is evaluated first before the table is joined.

RWDBJoinExpr
rwdbRightOuter(const RWDBJoinExpr& jexpr, 
               const RWDBTable& table);

Returns an RWDBJoinExpr that represents an encapsulation of the RIGHT OUTER JOIN SQL phrase between an outer join expression and a table. This does not add any precedence to the constructs.

RWDBJoinExpr
rwdbRightOuter(const RWDBJoinExpr& jexpr1, 
               const RWDBJoinExpr& jexpr2);

Returns an RWDBJoinExpr that represents an encapsulation of the RIGHT OUTER JOIN SQL phrase between two outer join expressions. This does not add any precedence to the constructs.

RWDBJoinExpr
rwdbOuter(const RWDBTable& table1, const RWDBTable& table2);

Returns an RWDBJoinExpr that represents an encapsulation of the FULL OUTER JOIN SQL phrase between two tables.

RWDBJoinExpr
rwdbOuter(const RWDBTable& table, 
          const RWDBJoinExpr& jexpr);

Returns an RWDBJoinExpr that represents an encapsulation of the FULL OUTER JOIN SQL phrase between a table and an outer join expression. For databases that support precedence in outer joins, the generated SQL adds precedence to jexpr, such that jexpr is evaluated first before the table is joined.

RWDBJoinExpr
rwdbOuter(const RWDBJoinExpr& jexpr, 
          const RWDBTable& table);

Returns an RWDBJoinExpr that represents an encapsulation of the FULL OUTER JOIN SQL phrase between an outer join expression and a table. This does not add any precedence to the constructs.

RWDBJoinExpr
rwdbOuter(const RWDBJoinExpr& jexpr1, 
          const RWDBJoinExpr& jexpr2);

Returns an RWDBJoinExpr that represents an encapsulation of the FULL OUTER JOIN SQL phrase between two outer join expressions. This does not add any precedence to the constructs.

RWDBJoinExpr
rwdbNaturalLeftOuter(const RWDBTable& table1, 
                     const RWDBTable& table2);

Returns an RWDBJoinExpr that represents an encapsulation of the NATURAL LEFT OUTER JOIN SQL phrase between two tables.

RWDBJoinExpr
rwdbNaturalLeftOuter(const RWDBTable& table, 
                     const RWDBJoinExpr& jexpr);

Returns an RWDBJoinExpr that represents an encapsulation of the NATURAL LEFT OUTER JOIN SQL phrase between a table and an outer join expression. For databases that support precedence in outer joins, the generated SQL adds precedence to jexpr, such that jexpr is evaluated first before the table is joined.

RWDBJoinExpr
rwdbNaturalLeftOuter(const RWDBJoinExpr& jexpr, 
                     const RWDBTable& table);

Returns an RWDBJoinExpr that represents an encapsulation of the NATURAL LEFT OUTER JOIN SQL phrase between an outer join expression and a table. This does not add any precedence to the constructs.

RWDBJoinExpr
rwdbNaturalLeftOuter(const RWDBJoinExpr& jexpr1, 
                     const RWDBJoinExpr& jexpr2);

Returns an RWDBJoinExpr that represents an encapsulation of the NATURAL LEFT OUTER JOIN SQL phrase between two outer join expressions. This does not add any precedence to the constructs.

RWDBJoinExpr
rwdbNaturalRightOuter(const RWDBTable& table1, 
                      const RWDBTable& table2);

Returns an RWDBJoinExpr that represents an encapsulation of the NATURAL RIGHT OUTER JOIN SQL phrase between two tables.

RWDBJoinExpr
rwdbNaturalRightOuter(const RWDBTable& table, 
                      const RWDBJoinExpr& jexpr);

Returns an RWDBJoinExpr that represents an encapsulation of the NATURAL RIGHT OUTER JOIN SQL phrase between a table and an outer join expression. For databases that support precedence in outer joins, the generated SQL adds precedence to jexpr, such that jexpr is evaluated first before the table is joined.

RWDBJoinExpr
rwdbNaturalRightOuter(const RWDBJoinExpr& jexpr, 
                      const RWDBTable& table);

Returns an RWDBJoinExpr that represents an encapsulation of the NATURAL RIGHT OUTER JOIN SQL phrase between an outer join expression and a table. This does not add any precedence to the constructs.

RWDBJoinExpr
rwdbNaturalRightOuter(const RWDBJoinExpr& jexpr1, 
                      const RWDBJoinExpr& jexpr2);

Returns an RWDBJoinExpr that represents an encapsulation of the NATURAL RIGHT OUTER JOIN SQL phrase between two outer join expressions. This does not add any precedence to the constructs.

RWDBJoinExpr
rwdbNaturalOuter(const RWDBTable& table1, 
                 const RWDBTable& table2);

Returns an RWDBJoinExpr that represents an encapsulation of the NATURAL FULL OUTER JOIN SQL phrase between two tables.

RWDBJoinExpr
rwdbNaturalOuter(const RWDBTable& table, 
                 const RWDBJoinExpr& jexpr);

Returns an RWDBJoinExpr that represents an encapsulation of the FULL OUTER JOIN SQL phrase between a table and an outer join expression. For databases that support precedence in outer joins, the generated SQL adds precedence to jexpr, such that jexpr is evaluated first before the table is joined.

RWDBJoinExpr
rwdbNaturalOuter(const RWDBJoinExpr& jexpr, 
                 const RWDBTable& table);

Returns an RWDBJoinExpr that represents an encapsulation of the NATURAL FULL OUTER JOIN SQL phrase between an outer join expression and a table. This does not add any precedence to the constructs.

RWDBJoinExpr
rwdbNaturalOuter(const RWDBJoinExpr& jexpr1, 
                 const RWDBJoinExpr& jexpr2);

Returns an RWDBJoinExpr that represents an encapsulation of the NATURAL FULL OUTER JOIN SQL phrase between two outer join expressions. This does not add any precedence to the constructs.

©Copyright 1999, Rogue Wave Software, Inc.
Contact Rogue Wave about documentation or support issues.