CONNX supports two types of inner join syntax.

 

Syntax 1.  <table_1.column1> = <table_2.column2>

 

Example:

SELECT * FROM table_1, table_2 WHERE Table_1.key = table_2.key

 

 

Syntax 2. <table_1> INNER JOIN <table_2> ON <table_1.column1> = <table_2.column2> [ AND <table_1.column2 = table_2.column3> ...]

 

Example:

SELECT * FROM Table_1 INNER JOIN Table_2 ON Table_1.key = Table_2.key