aboutsummaryrefslogtreecommitdiff
path: root/doc
diff options
context:
space:
mode:
authorBoris Kolpackov <boris@codesynthesis.com>2015-02-06 08:57:30 +0200
committerBoris Kolpackov <boris@codesynthesis.com>2015-02-06 08:57:30 +0200
commitf5e457f5dee11cbd20fc3557f79d6e1f235fb89f (patch)
tree17b21ea5494e37aea6a336284990ebb6424466e8 /doc
parent2ca4828d303fdd27c573429910f7a25fd1e3727c (diff)
Implement join types support in views
Diffstat (limited to 'doc')
-rw-r--r--doc/manual.xhtml18
1 files changed, 14 insertions, 4 deletions
diff --git a/doc/manual.xhtml b/doc/manual.xhtml
index 3e941dc..fce5302 100644
--- a/doc/manual.xhtml
+++ b/doc/manual.xhtml
@@ -9953,6 +9953,7 @@ struct employee_employer
<p><code><b>object(</b><i>name</i>
[<b>=</b> <i>alias</i>]
+ [<i>join-type</i>]
[<b>:</b> <i>join-condition</i>]<b>)</b></code></p>
<p>The <i>name</i> part is a potentially qualified persistent class
@@ -9960,12 +9961,16 @@ struct employee_employer
part gives this object an alias. If provided, the alias is used
in several contexts instead of the object's unqualified name. We
will discuss aliases further as we cover each of these contexts
- below. The optional <i>join-condition</i> part provides the
+ below. The optional <i>join-type</i> part specifies the way this
+ object is associated. It can be <code>left</code>, <code>right</code>,
+ <code>full</code>, <code>inner</code>, and <code>cross</code>
+ with <code>left</code> being the default.
+ Finally, the optional <i>join-condition</i> part provides the
criteria which should be used to associate this object with any
of the previously associated objects or, as we will see in
<a href="#10.4">Section 10.4, "Mixed Views"</a>, tables. Note that
while the first associated object can have an alias, it cannot
- have a join condition.</p>
+ have a join type or condition.</p>
<p>For each subsequent associated object the ODB compiler needs
a join condition and there are several ways to specify
@@ -10784,6 +10789,7 @@ struct employee_max_vacation
<p><code><b>table("</b><i>name</i><b>"</b>
[<b>=</b> <b>"</b><i>alias</i><b>"</b>]
+ [<i>join-type</i>]
[<b>:</b> <i>join-condition</i>]<b>)</b></code></p>
<p>The <i>name</i> part is a database table name. The optional
@@ -10791,12 +10797,16 @@ struct employee_max_vacation
alias must be used instead of the table whenever a reference
to a table is used. Contexts where such a reference may
be needed include the join condition (discussed below),
- column names, and query expressions. The optional <i>join-condition</i>
+ column names, and query expressions. The optional <i>join-type</i>
+ part specifies the way this table is associated. It can
+ be <code>left</code>, <code>right</code>, <code>full</code>,
+ <code>inner</code>, and <code>cross</code> with <code>left</code>
+ being the default. Finally, the optional <i>join-condition</i>
part provides the criteria which should be used to associate this
table with any of the previously associated tables or, as we will see in
<a href="#10.4">Section 10.4, "Mixed Views"</a>, objects. Note that
while the first associated table can have an alias, it cannot have
- a join condition.</p>
+ a join type or condition.</p>
<p>Similar to object views, for each subsequent associated table the
ODB compiler needs a join condition. However, unlike for object views,