Micro Focus XDBC 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.