<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><!-- InstanceBegin template="../Templates/DocTemp.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>SQL Reference - Joins</title>
<!-- InstanceEndEditable --> 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="../docs.css" rel="stylesheet" type="text/css">
<script language="JavaScript1.2" src="../docs.js"></script>
<!-- InstanceBeginEditable name="head" --><!-- InstanceEndEditable -->
</head>

<body>
<table width="100%" class="lightblue" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><a href="http://www.omnidex.com"><img src="../images/flatlogo.gif" width="95" height="25" hspace="3" vspace="3" border="0"></a></td>
    <td><img src="../images/omnidex.gif" width="109" height="25" hspace="3" vspace="3"></td>
    <td align="right" valign="top"><p class="banner"><a href="../Contents.htm">Contents</a> 
        | <a href="../Quick%20Links.htm">Quick Links</a></p></td>
  </tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td width="175" class="bar"><p class="banner">&nbsp;</p></td>
    <td align="right" class="bar"> <!-- InstanceBeginEditable name="Section Title" -->
      <h1>SQL Reference</h1>
      <!-- InstanceEndEditable --></td>
  </tr>
  <tr> 
    <td width="175" class="left1 lightblue"><img src="../images/blank.gif" width="10" height="20"> 
    </td>
    <td valign="top" class="left1 lightblue">&nbsp; </td>
  </tr>
  <tr> 
    <td width="175" valign="top" class="left"><!-- InstanceBeginEditable name="leftnav" --> 
      <p><a href="#syntax">Syntax</a></p>
      <p><a href="#types">Types</a></p>
      <p><a href="#example">Examples</a></p>
      <p class="line">&nbsp;</p>
      <p><a href="SQL%20Reference.htm">SQL Reference</a></p>
      <p><a href="SELECT%20Statement/SELECT%20Statement.htm">SELECT Statement</a></p>
      <p>Joins</p>
      <p><a href="Nested%20Queries.htm">Nested Queries</a></p>
      <p><a href="SET%20Operations.htm">Set Operations</a></p>
      <p><a href="ON%20CURSOR%20ON%20INSTANCE.htm">ON CURSOR | INSTANCE</a></p>
      <p><a href="WITH%20Options.htm">WITH Options</a></p>
      <p><a href="Commands.htm">Commands</a></p>
      <p><a href="Functions.htm">Functions</a></p>
      <!-- InstanceEndEditable --></td>
    <td valign="top" class="content"> <!-- InstanceBeginEditable name="Content" --> 
      <h2>Joins</h2>
      <p>Joins are operations where two tables are logically &quot;joined&quot; 
        or linked together in a SQL statement using fields common to both tables. 
        A join in a SQL statement allows data to be qualified and retrieved from 
        one or more of these tables based on this link.</p>
      <p>For example, in a database, every customer in a customers table will 
        have a customer number or some other unique identifying field. The orders 
        table will link each order to a specific customer by including a link 
        field containing that unique customer id. Orders can then be retrieved 
        for a specific customer.</p>
      <p>Data retrieved from two tables that are not joined will result in a cartesian 
        product. This can greatly inhibit query performance and distort aggregations.</p>
      <p><img src="../images/note.gif" width="12" height="15" align="left">If 
        the WHERE clause criteria in an outer join references both tables and 
        is ANDd together, the query will be result in an inner join. For example, 
        the following two SQL statements will return the same results:</p>
      <h5>Left Outer Join</h5>
      <p class="ex"> SELECT ... FROM table1 LEFT JOIN table2 ON table1.linkfield 
        = table2.linkfield<br>
        WHERE table1.column = criteria1 AND table2.column = criteria2</p>
      <h5>Inner Join</h5>
      <p class="ex">SELECT ... FROM table1, table2 <br>
        WHERE table1.linkfield = table2.linkfield <br>
        AND table1.column = criteria1 AND table2.column = criteria2</p>
      <p class="line">&nbsp;</p>
      <h3><a name="syntax"></a>Syntax</h3>
      <p class="ex">SELECT ... FROM table1 <br>
        [ LEFT | RIGHT ] [OUTER] JOIN table2 <br>
        ON table1.linkfield = table2.linkfield ...</p>
      <p>or</p>
      <p class="ex">SELECT ... FROM table1, table2<br>
        WHERE table1.linkfield = table2.linkfield ...</p>
      <p><img src="../images/note.gif" width="12" height="15" align="left">Omnidex 
        does not support the SQL Server and Oracle specific outer join syntax: 
      </p>
      <p class="ex">WHERE table1.linkfield*=table2.linkfield<br>
        WHERE table1.linkfield=table2.linkfield(+)</p>
      <p class="line">&nbsp;</p>
      <h3><a name="types"></a>Join Types</h3>
      <p>Omnidex supports three types of joins: inner joins, left outer joins, 
        right outer joins.</p>
      <h5>Inner Joins</h5>
      <p>Most joins in an SQL SELECT statement, are inner joins. This means that 
        two tables are joined together and rows are qualified for the left operand 
        where related records exist in the right operand. </p>
      <p>For example, when joining the customers table to the orders table, customers 
        are only qualified when they have orders in the orders table. This eliminates 
        all customers that do not have orders.</p>
      <p>Inner joins can be specified in an SQL SELECT statement in a couple of 
        ways.</p>
      <p>One way is to use a JOIN statement in the FROM clause of an SQL SELECT 
        statement.</p>
      <p class="ex">SELECT p.acct, p.company, o.order_date <br>
        FROM prospects p <br>
        JOIN orders o ON p.acct = o.acct</p>
      <p>Another way is to join the tables in a WHERE clause predicate.</p>
      <p class="ex">SELECT p.acct, p.company, o.order_date <br>
        FROM prospects p, orders o <br>
        WHERE p.acct = o.acct</p>
      <p>Both example produce the same results and are fully supported by Omnidex.</p>
      <p>&nbsp;</p>
      <h5>Left Outer Joins</h5>
      <p> A left outer join will qualify all rows in the left operand whether 
        or not they have related records in the right operand.</p>
      <p>For example, when using a left outer join on customers to orders, all 
        customers and only orders that have related customer records will qualify. 
        Null indicators will be returned for the orders fields where orders do 
        not exist for a customer.</p>
      <p class="ex">SELECT p.acct, p.company, o.order_date <br>
        FROM prospects p<br>
        LEFT JOIN orders o ON p.acct = o.acct</p>
      <p class="ex">SELECT p.acct, p.company, o.order_date <br>
        FROM prospects p<br>
        LEFT OUTER JOIN orders o ON p.acct = o.acct</p>
      <p>Both of these statements are identical. The OUTER keyword is optional.</p>
      <p>The target table, orders in the above example, cannot be a UNION VIEW 
        (see Partitioning). However, the UNION VIEW can be the FROM table, propsects 
        above.</p>
      <p>&nbsp;</p>
      <h5>Right Outer Joins</h5>
      <p>Similar to left outer joins, a right outer join in the same scenario 
        (see Left Outer Joins, above), will qualify all orders and only those 
        customers that have related orders. Null indicators will be returned for 
        the customer fields where a customer record does not exist for an order.</p>
      <p>When encountering a right outer join, Omnidex will attempt to convert 
        the join into a left outer join. For example:</p>
      <p class="ex">SELECT p.acct, p.company, o.order_date <br>
        FROM orders o <br>
        RIGHT JOIN prospects p ON o.acct = p.acct</p>
      <p>will be converted to:</p>
      <p class="ex">SELECT p.acct, p.company, o.order_date <br>
        FROM prospects p<br>
        LEFT JOIN orders o ON p.acct = o.acct</p>
      <p>Both statements return ALL prospects and their order dates if they exist 
        or null indicators if they don't. The OUTER keyword is optional.</p>
      <p>If Omnidex is unable to convert a right outer join to a left outer join, 
        similar to the above example, the SQL statement will fail and return an 
        error.</p>
      <p class="line">&nbsp;</p>
      <h3><a name="example"></a>Examples</h3>
      <p>These examples demonstrate the difference between inner and outer joins. 
      </p>
      <h5>Inner Join</h5>
      <p>This statement counts the number of distinct account numbers in the prospects 
        table, where that account number also occurs at least once in the orders 
        table. This means that three prospects also have orders.</p>
      <p class="ex">SELECT count(distinct p.acct) FROM prospects p <br>
        JOIN orders o ON p.acct = o.acct</p>
      <p class="ex">COUNT(DISTINCT PROSPECTS.ACCT)<br>
        ------------------------------<br>
        3</p>
      <p class="ex">1 row returned</p>
      <h5>Left Outer Join</h5>
      <p>This statement counts the number of distinct account numbers in the prospects 
        table, whether or not they have orders in the orders table.</p>
      <p class="ex">SELECT count(distinct p.acct) FROM prospects p <br>
        LEFT JOIN orders o ON p.acct = o.acct</p>
      <p class="ex">COUNT(DISTINCT PROSPECTS.ACCT)<br>
        ------------------------------<br>
        10</p>
      <p class="ex">1 row returned</p>
      <h5>Inner Join</h5>
      <p>This statement returns the account number and company name from the prospects 
        table and the order date from the orders table. Because this is an inner 
        join, only prospects that have related records in the orders table will 
        be returned.</p>
      <p class="ex">SELECT p.acct, p.company, o.order_date FROM prospects p, orders 
        o<br>
        WHERE p.acct = o.acct AND p.acct in (3,4)</p>
      <table width="100%" cellpadding="0" cellspacing="0">
        <tr> 
          <td><p class="ex">ACCT<br>
              -----------</p></td>
          <td><p class="ex">COMPANY<br>
              -----------------------------</p></td>
          <td><p class="ex">ORDER_DATE<br>
              --------------------</p></td>
        </tr>
        <tr> 
          <td><p class="ex">3</p></td>
          <td><p class="ex">GlenAir Corporation</p></td>
          <td><p class="ex">Feb 8, 2003</p></td>
        </tr>
      </table>
      <p class="ex">1 row returned</p>
      <h5>Left Outer Join</h5>
      <p>The same statement using a left outer join returns an additional record. 
        Because this is a left outer join, all prospects that qualify with the 
        given criteria, acct=3 or acct=4, are returned and those that do not have 
        orders in the orders table have a null indicator in the order_date field.</p>
      <p class="ex">SELECT p.acct, p.company, o.order_date FROM prospects p, orders 
        o<br>
        WHERE p.acct = o.acct AND p.acct in (3,4)</p>
      <table width="100%" cellpadding="0" cellspacing="0">
        <tr> 
          <td><p class="ex">ACCT<br>
              -----------</p></td>
          <td><p class="ex">COMPANY<br>
              -----------------------------</p></td>
          <td><p class="ex">ORDER_DATE<br>
              --------------------</p></td>
        </tr>
        <tr> 
          <td><p class="ex">3</p></td>
          <td><p class="ex">GlenAir Corporation</p></td>
          <td><p class="ex">Feb 8, 2003</p></td>
        </tr>
        <tr> 
          <td><p class="ex">4</p></td>
          <td><p class="ex">Data Dimensions</p></td>
          <td><p class="ex">&lt;NULL&gt;</p></td>
        </tr>
      </table>
      <p class="ex">2 rows returned</p>
      <p>&nbsp; </p>
      <!-- InstanceEndEditable --><P align="right"><a href="#">Top</a> </P>
	  </td>
  </tr>
  <tr>
    <td width="175" class="bbar">
<p>&nbsp;</p></td>
    <td align="right" valign="middle" class="bbar"> <p class="banner">Omnidex 
        Version 4.1 Build 1 - E10.04 - Dynamic Information Systems Corporation 
        - Copyright &copy; 2004</p></td>
  </tr>
</table>
<div class="menu0" id="m1" onMouseOver="changeClass('menu1','m1'); changeVisibility('visible','s1');" onMouseOut="changeClass('menu0','m1'); changeVisibility('hidden','s1');"> 
  <a href="../index.htm">Home</a></div>      
<div class="menu0" id="m2" onMouseOver="changeClass('menu1','m2'); changeVisibility('visible','s2');" onMouseOut="changeClass('menu0','m2'); changeVisibility('hidden','s2');"> 
  <a href="../Omnidex%20Concepts/Omnidex%20Overview.htm">Omnidex</a></div>      
<div class="menu0" id="m3" onMouseOver="changeClass('menu1','m3'); changeVisibility('visible','s3');" onMouseOut="changeClass('menu0','m3'); changeVisibility('hidden','s3');"> 
  <a href="../Getting%20Started/Getting%20Started.htm">Getting Started </a></div>      
<div class="menu0" id="m4" onMouseOver="changeClass('menu1','m4'); changeVisibility('visible','s4');" onMouseOut="changeClass('menu0','m4'); changeVisibility('hidden','s4');"> 
  <a href="../Development/Development.htm">Development</a></div>      
<div class="menu0" id="m5" onMouseOver="changeClass('menu1','m5'); changeVisibility('visible','s5');" onMouseOut="changeClass('menu0','m5'); changeVisibility('hidden','s5');"> 
  <a href="../Utilities/Utilities.htm">Utilities</a></div>      
<div class="menu0" id="m6" onMouseOver="changeClass('menu1','m6'); changeVisibility('visible','s6');" onMouseOut="changeClass('menu0','m6'); changeVisibility('hidden','s6');"> 
  <a href="../Appendix/Appendix.htm">Appendix</a></div>
    <td>&nbsp;</td>
  </tr>
</table> 
<table id="s1" border="0" cellspacing="0" cellpadding="0" onMouseOver="changeClass('menu1','m1'); changeVisibility('visible','s1');" onMouseOut="changeClass('menu0','m1'); changeVisibility('hidden','s1');">
  <tr> 
    <td id="s11" class="menu1" onMouseOver="changeClass('menu0','s11');" onMouseOut="changeClass('menu1','s11');"><a href="../Whats%20New.htm">What's 
      New!</a></td>
  </tr>
  <tr> 
    <td id="s12" class="menu1" onMouseOver="changeClass('menu0','s12');" onMouseOut="changeClass('menu1','s12');"><a href="../Quick%20Links.htm">Quick 
      Links</a></td>
  </tr>
  <tr> 
    <td id="s13" class="menu1" onMouseOver="changeClass('menu0','s13');" onMouseOut="changeClass('menu1','s13');"><a href="../Contents.htm">Contents</a></td>
  </tr>
</table>
<table id="s2" border="0" cellspacing="0" cellpadding="0" onMouseOver="changeClass('menu1','m2'); changeVisibility('visible','s2');" onMouseOut="changeClass('menu0','m2'); changeVisibility('hidden','s2');">
  <tr> 
    <td id="s21" class="menu1" onMouseOver="changeClass('menu0','s21');" onMouseOut="changeClass('menu1','s21');"><a href="../Omnidex%20Concepts/Features/Features.htm">Features</a></td>
  </tr>
  <tr> 
    <td id="s22" class="menu1" onMouseOver="changeClass('menu0','s22');" onMouseOut="changeClass('menu1','s22');"><a href="../Omnidex%20Concepts/Indexing%20Strategies/Indexing%20Strategies.htm">Indexing 
      Strategies</a></td>
  </tr>
  <tr> 
    <td id="s23" class="menu1" onMouseOver="changeClass('menu0','s23');" onMouseOut="changeClass('menu1','s23');"><a href="../Omnidex%20Concepts/Indexing%20Options/Indexing%20Options.htm">Indexing 
      Options </a></td>
  </tr>
  <tr> 
    <td id="s24" class="menu1" onMouseOver="changeClass('menu0','s24');" onMouseOut="changeClass('menu1','s24');"><a href="../Omnidex%20Concepts/Index%20Maintenance/Index%20Maintenance.htm">Index 
      Maintenance </a></td>
  </tr>
  <tr> 
    <td id="s25" class="menu1" onMouseOver="changeClass('menu0','s25');" onMouseOut="changeClass('menu1','s25');"><a href="../Omnidex%20Concepts/Partitioning/Partitioning.htm">Optimization</a></td>
  </tr>
  <tr> 
    <td id="s26" class="menu1" onMouseOver="changeClass('menu0','s26');" onMouseOut="changeClass('menu1','s26');"><a href="../Omnidex%20Concepts/Index%20Maintenance/Index%20Maintenance.htm">Partitioning</a></td>
  </tr>
  <tr> 
    <td id="s27" class="menu1" onMouseOver="changeClass('menu0','s27');" onMouseOut="changeClass('menu1','s27');"><a href="../Omnidex%20Concepts/Text/Omnidex%20Text.htm">Omnidex Text</a></td>
  </tr>
</table>
<table id="s3" border="0" cellspacing="0" cellpadding="0" onMouseOver="changeClass('menu1','m3'); changeVisibility('visible','s3');" onMouseOut="changeClass('menu0','m3'); changeVisibility('hidden','s3');">
  <tr> 
    <td id="s31" class="menu1" onMouseOver="changeClass('menu0','s31');" onMouseOut="changeClass('menu1','s31');"><a href="../Getting%20Started/1%20-%20Installation%20and%20Setup.htm">Server 
      Setup Guides</a></td>
  </tr>
  <tr> 
    <td id="s32" class="menu1" onMouseOver="changeClass('menu0','s32');" onMouseOut="changeClass('menu1','s32');"><a href="../Getting%20Started/Omnidex%20Client/Windows%20Client.htm">Windows 
      Client</a></td>
  </tr>
  <tr> 
    <td id="s33" class="menu1" onMouseOver="changeClass('menu0','s33');" onMouseOut="changeClass('menu1','s33');"><a href="../Database%20Platforms/Supported%20Database%20Platforms.htm">Database 
      Platforms </a></td>
  </tr>
  <tr> 
    <td id="s34" class="menu1" onMouseOver="changeClass('menu0','s34');" onMouseOut="changeClass('menu1','s34');"><a href="../Environment%20Catalog/Environment%20Catalog.htm">Environment 
      Catalog</a> </td>
  </tr>
</table>
<table id="s4" border="0" cellspacing="0" cellpadding="0" onMouseOver="changeClass('menu1','m4'); changeVisibility('visible','s4');" onMouseOut="changeClass('menu0','m4'); changeVisibility('hidden','s4');">
  <tr> 
    <td id="s41" class="menu1" onMouseOver="changeClass('menu0','s41');" onMouseOut="changeClass('menu1','s41');"><a href="../SQL%20Reference/SQL%20Reference.htm">SQL 
      Reference</a> </td>
  </tr>
  <tr> 
    <td id="s42" class="menu1" onMouseOver="changeClass('menu0','s42');" onMouseOut="changeClass('menu1','s42');"><a href="../Development/ODBC/ODBC.htm">ODBC</a></td>
  </tr>
  <tr> 
    <td id="s43" class="menu1" onMouseOver="changeClass('menu0','s43');" onMouseOut="changeClass('menu1','s43');"><a href="../Development/JDBC/JDBC.htm">JDBC</a></td>
  </tr>
  <tr> 
    <td id="s44" class="menu1" onMouseOver="changeClass('menu0','s44');" onMouseOut="changeClass('menu1','s44');"><a href="../Development/OmniAccess%20API/OmniAccess%20API.htm">OmniAccess 
      API</a></td>
  </tr>
  <tr> 
    <td id="s45" class="menu1" onMouseOver="changeClass('menu0','s45');" onMouseOut="changeClass('menu1','s45');"><a href="../Development/Debugging/OMNIDEX_DEBUG.htm">Debugging</a></td>
  </tr>
</table>
<table id="s5" border="0" cellspacing="0" cellpadding="0" onMouseOver="changeClass('menu1','m5'); changeVisibility('visible','s5');" onMouseOut="changeClass('menu0','m5'); changeVisibility('hidden','s5');">
  <tr> 
    <td id="s51" class="menu1" onMouseOver="changeClass('menu0','s51');" onMouseOut="changeClass('menu1','s51');"><A href="../Utilities/DBINSTAL/DBINSTAL.htm">DBINSTAL</A></td>
  </tr>
  <tr> 
    <td id="s52" class="menu1" onMouseOver="changeClass('menu0','s52');" onMouseOut="changeClass('menu1','s52');"><a href="../Utilities/DSEDIT/DSEDIT.htm">DSEDIT</a></td>
  </tr>
  <tr> 
    <td id="s53" class="menu1" onMouseOver="changeClass('menu0','s53');" onMouseOut="changeClass('menu1','s53');"><a href="../Utilities/NSADMIN/NSADMIN.htm">NSADMIN</a></td>
  </tr>
  <tr> 
    <td id="s54" class="menu1" onMouseOver="changeClass('menu0','s54');" onMouseOut="changeClass('menu1','s54');"><a href="../Utilities/OACOMP/OACOMP.htm">OACOMP</a></td>
  </tr>
  <tr> 
    <td id="s55" class="menu1" onMouseOver="changeClass('menu0','s55');" onMouseOut="changeClass('menu1','s55');"><a href="../Utilities/OADECOMP/OADECOMP.htm">OADECOMP</a></td>
  </tr>
  <tr> 
    <td id="s56" class="menu1" onMouseOver="changeClass('menu0','s56');" onMouseOut="changeClass('menu1','s56');"><a href="../Utilities/OAHELPER/OAHELPER.htm">OAHELPER</a></td>
  </tr>
  <tr> 
    <td id="s57" class="menu1" onMouseOver="changeClass('menu0','s57');" onMouseOut="changeClass('menu1','s57');"><A href="../Utilities/ODXAIM/ODXAIM.htm">ODXAIM</A></td>
  </tr>
  <tr> 
    <td id="s58" class="menu1" onMouseOver="changeClass('menu0','s58');" onMouseOut="changeClass('menu1','s58');"><a href="../Utilities/ODXMAKE/ODXMAKE.htm">ODXMAKE</a></td>
  </tr>
  <tr> 
    <td id="s59" class="menu1" onMouseOver="changeClass('menu0','s59');" onMouseOut="changeClass('menu1','s59');"><a href="../Utilities/ODXNET/ODXNET.htm">ODXNET</a></td>
  </tr>
  <tr> 
    <td id="s510" class="menu1" onMouseOver="changeClass('menu0','s510');" onMouseOut="changeClass('menu1','s510');"><A href="../Utilities/ODXQUERY/ODXQUERY.htm">ODXQUERY</A></td>
  </tr>
  <tr> 
    <td id="s511" class="menu1" onMouseOver="changeClass('menu0','s511');" onMouseOut="changeClass('menu1','s511');"><a href="../Utilities/ODXSQL/ODXSQL.htm">ODXSQL</a></td>
  </tr>
  <tr> 
    <td id="s512" class="menu1" onMouseOver="changeClass('menu0','s512');" onMouseOut="changeClass('menu1','s512');"><a href="../Utilities/REGMAINT/REGMAINT.htm">REGMAINT</a></td>
  </tr>
  <tr> 
    <td id="s513" class="menu1" onMouseOver="changeClass('menu0','s513');" onMouseOut="changeClass('menu1','s513');"><A href="../Utilities/REGTEST/REGTEST.htm">REGTEST</A></td>
  </tr>
  <tr> 
    <td id="s514" class="menu1" onMouseOver="changeClass('menu0','s514');" onMouseOut="changeClass('menu1','s514');"><a href="../Utilities/SNOWGEN/SNOWGEN.htm">SNOWGEN</a></td>
  </tr>
  <tr> 
    <td id="s515" class="menu1" onMouseOver="changeClass('menu0','s515');" onMouseOut="changeClass('menu1','s515');"><a href="../Utilities/SYSINFO/SYSINFO.htm">SYSINFO</a></td>
  </tr>
  <tr> 
    <td id="s516" class="menu1" onMouseOver="changeClass('menu0','s516');" onMouseOut="changeClass('menu1','s516');"><a href="../Utilities/VERSIONS/VERSIONS.htm">VERSIONS</a></td>
  </tr>
  <tr> 
    <td id="s517" class="menu1" onMouseOver="changeClass('menu0','s517');" onMouseOut="changeClass('menu1','s517');"><a href="../Utilities/VIEWGEN/VIEWGEN.htm">VIEWGEN</a></td>
  </tr>
</table>
<table id="s6" border="0" cellspacing="0" cellpadding="0" onMouseOver="changeClass('menu1','m6'); changeVisibility('visible','s6');" onMouseOut="changeClass('menu0','m6'); changeVisibility('hidden','s6');">
  <tr> 
    <td id="s61" class="menu1" onMouseOver="changeClass('menu0','s61');" onMouseOut="changeClass('menu1','s61');"><a href="../Appendix/Cardinality.htm">Cardinality</a></td>
  </tr>
  <tr> 
    <td id="s62" class="menu1" onMouseOver="changeClass('menu0','s62');" onMouseOut="changeClass('menu1','s62');"><a href="../Appendix/Date%20Formats.htm">Date 
      Formats </a></td>
  </tr>
  <tr> 
    <td id="s63" class="menu1" onMouseOver="changeClass('menu0','s63');" onMouseOut="changeClass('menu1','s63');"><a href="../Appendix/Environment%20Variables.htm">Environment 
      Variables </a></td>
  </tr>
  <tr> 
    <td id="s64" class="menu1" onMouseOver="changeClass('menu0','s64');" onMouseOut="changeClass('menu1','s64');"><a href="../Appendix/File%20Name%20Handling.htm">File 
      Name Handling</a></td>
  </tr>
  <tr> 
    <td id="s65" class="menu1" onMouseOver="changeClass('menu0','s65');" onMouseOut="changeClass('menu1','s65');"><a href="../Appendix/Glossary%20A.htm">Glossary</a></td>
  </tr>
  <tr> 
    <td id="s66" class="menu1" onMouseOver="changeClass('menu0','s66');" onMouseOut="changeClass('menu1','s66');"><a href="../Appendix/Null.htm">Null</a></td>
  </tr>
  <tr> 
    <td id="s67" class="menu1" onMouseOver="changeClass('menu0','s67');" onMouseOut="changeClass('menu1','s67');"><a href="../Appendix/OAGLOBAL.htm">OAGLOBAL</a></td>
  </tr>
  <tr> 
    <td id="s68" class="menu1" onMouseOver="changeClass('menu0','s68');" onMouseOut="changeClass('menu1','s68');"><a href="../Appendix/Operating%20Limits.htm">Operating 
      Limits</a></td>
  </tr>
  <tr> 
    <td id="s69" class="menu1" onMouseOver="changeClass('menu0','s69');" onMouseOut="changeClass('menu1','s69');"><a href="../Appendix/Provided%20Managed%20Synonym%20Lists.htm">Managed 
      Synonym Lists</a></td>
  </tr>
  <tr> 
    <td id="s70" class="menu1" onMouseOver="changeClass('menu0','s70');" onMouseOut="changeClass('menu1','s70');"><a href="../Appendix/Reserved%20Words.htm">Reserved 
      Words</a></td>
  </tr>
  <tr> 
    <td id="s71" class="menu1" onMouseOver="changeClass('menu0','s71');" onMouseOut="changeClass('menu1','s71');"><a href="../Appendix/Supported%20Datatypes.htm">Supported 
      Data Types</a></td>
  </tr>
</table>
<p>&nbsp;</p>
</body>
<!-- InstanceEnd --></html>
