db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kahat...@apache.org
Subject svn commit: r937962 - /db/derby/docs/trunk/src/ref/rrefsqljnaturaljoin.dita
Date Mon, 26 Apr 2010 08:38:10 GMT
Author: kahatlen
Date: Mon Apr 26 08:38:09 2010
New Revision: 937962

URL: http://svn.apache.org/viewvc?rev=937962&view=rev
Log:
DERBY-4506: Document NATURAL JOIN in the reference manual

Corrected information about expansion of asterisk (*) and references
to unqualified common columns.

Modified:
    db/derby/docs/trunk/src/ref/rrefsqljnaturaljoin.dita

Modified: db/derby/docs/trunk/src/ref/rrefsqljnaturaljoin.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqljnaturaljoin.dita?rev=937962&r1=937961&r2=937962&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqljnaturaljoin.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqljnaturaljoin.dita Mon Apr 26 08:38:09 2010
@@ -46,7 +46,7 @@ to the following list of columns (in thi
 </p>
 
 <ul>
-<li>All the common columns in the first (left) table</li>
+<li>All the common columns</li>
 <li>Every column in the first (left) table that is not a common column</li>
 <li>Every column in the second (right) table that is not a common column</li>
 </ul>
@@ -56,6 +56,14 @@ An asterisk qualified by a table name (f
 be expanded to every column of that table that is not a common column.
 </p>
 
+<p>
+If a common column is referenced without being qualified by a table
+name, the column reference points to the column in the first (left)
+table if the join is an INNER JOIN or a LEFT OUTER JOIN. If it is a
+RIGHT OUTER JOIN, unqualified references to a common column point to
+the column in the second (right) table.
+</p>
+
 </section>
 
 <refsyn>



Mime
View raw message