CONNX supports three types of outer join syntax.
Syntax 1. {oj <table_1> LEFT|RIGHT OUTER JOIN <table_2> ON <table_1.column1> = <table_2.column2> [ AND <table_1.column2 = table_2.column3> ...] }
Example:
SELECT * FROM {oj Table_1 LEFT OUTER JOIN Table_2 ON Table_1.key = Table_2.key}
or
SELECT * FROM {oj Table_1 RIGHT OUTER JOIN Table_2 ON Table_1.key = Table_2.key}
Syntax 2. <table_1.column1> *= <table_2.column2>
Example:
SELECT * FROM table_1, table_2 WHERE Table_1.key *= table_2.key
Note: Do not use this syntax for Adabas tables. Instead, use the OUTER JOIN syntax in the example below.
Syntax 3. <table_1> LEFT|RIGHT OUTER JOIN <table_2> ON <table_1.column1> = <table_2.column2> [ AND <table_1.column2 = table_2.column3> ...]
Example:
SELECT * FROM Table_1 LEFT OUTER JOIN Table_2 ON Table_1.key = Table_2.key
or
SELECT * FROM Table_1 RIGHT OUTER JOIN Table_2 ON Table_1.key = Table_2.key