Outer Joins

AcuXDBC supports OUTER joins, including LEFT, RIGHT, and FULL. The outer joins follow the FROM clause and are of the form:

<LEFT | RIGHT | FULL> OUTER JOIN <tablename> ON <column1> = <column2>

where <column1> is a column in <tablename> and <column2> is a column in another FROM clause table.