55 lines
3.7 KiB
HTML
55 lines
3.7 KiB
HTML
|
<?xml version="1.0" encoding="UTF-8"?>
|
||
|
|
<!DOCTYPE html
|
||
|
|
PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
|
||
|
|
<html lang="en-us" xml:lang="en-us">
|
||
|
|
<head>
|
||
|
|
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
|
||
|
|
<meta name="security" content="public" />
|
||
|
|
<meta name="Robots" content="index,follow" />
|
||
|
|
<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
|
||
|
|
<meta name="DC.Type" content="reference" />
|
||
|
|
<meta name="DC.Title" content="Right outer join" />
|
||
|
|
<meta name="abstract" content="A right outer join returns all the rows that an inner join returns plus one row for each of the other rows in the second table that did not have a match in the first table. It is the same as a left outer join with the tables specified in the opposite order." />
|
||
|
|
<meta name="description" content="A right outer join returns all the rows that an inner join returns plus one row for each of the other rows in the second table that did not have a match in the first table. It is the same as a left outer join with the tables specified in the opposite order." />
|
||
|
|
<meta name="DC.subject" content="SELECT statement, RIGHT OUTER JOIN, table, examples, RIGHT OUTER JOIN, right outer join" />
|
||
|
|
<meta name="keywords" content="SELECT statement, RIGHT OUTER JOIN, table, examples, RIGHT OUTER JOIN, right outer join" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafyjoin.htm" />
|
||
|
|
<meta name="copyright" content="(C) Copyright IBM Corporation 1998, 2006" />
|
||
|
|
<meta name="DC.Rights.Owner" content="(C) Copyright IBM Corporation 1998, 2006" />
|
||
|
|
<meta name="DC.Format" content="XHTML" />
|
||
|
|
<meta name="DC.Identifier" content="rbafyrojo" />
|
||
|
|
<meta name="DC.Language" content="en-us" />
|
||
|
|
<!-- All rights reserved. Licensed Materials Property of IBM -->
|
||
|
|
<!-- US Government Users Restricted Rights -->
|
||
|
|
<!-- Use, duplication or disclosure restricted by -->
|
||
|
|
<!-- GSA ADP Schedule Contract with IBM Corp. -->
|
||
|
|
<link rel="stylesheet" type="text/css" href="./ibmdita.css" />
|
||
|
|
<link rel="stylesheet" type="text/css" href="./ic.css" />
|
||
|
|
<title>Right outer join</title>
|
||
|
|
</head>
|
||
|
|
<body id="rbafyrojo"><a name="rbafyrojo"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">Right outer join</h1>
|
||
|
|
<div><p>A right outer join returns all the rows that an inner join returns
|
||
|
|
plus one row for each of the other rows in the second table that did not have
|
||
|
|
a match in the first table. It is the same as a left outer join with the tables
|
||
|
|
specified in the opposite order.</p>
|
||
|
|
<div class="section"><p>The query that was used as the left outer join example can be
|
||
|
|
rewritten as a right outer join as follows:</p>
|
||
|
|
</div>
|
||
|
|
<div class="example"> <pre> <strong>SELECT</strong> EMPNO, LASTNAME, PROJNO
|
||
|
|
<strong>FROM</strong> CORPDATA.PROJECT <strong>RIGHT OUTER JOIN</strong> CORPDATA.EMPLOYEE
|
||
|
|
<strong>ON</strong> EMPNO = RESPEMP
|
||
|
|
<strong>WHERE</strong> LASTNAME > 'S'</pre>
|
||
|
|
</div>
|
||
|
|
<div class="section"><p>The results of this query are identical to the results from the
|
||
|
|
left outer join query.</p>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbafyjoin.htm" title="Sometimes the information you want to see is not in a single table. To form a row of the result table, you might want to retrieve some column values from one table and some column values from another table. You can retrieve and join column values from two or more tables into a single row.">Join data from more than one table</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|