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