Join Custom Condition (4 way)

Joins FOUR tables:
T1
T2
T3
T4

(in order of the input ports from top to bottom)

Specify the condition, using SQL (H2 Database syntax)

e.g.
t1."id" = t2."id" and
t2."id" = t3."id" and
t3."id" = t4."id"

table column names are case-sensitive and will work without including the double-quotes only if the source table and table column names are all upper case.

It is best to always wrap the column names in double-quotes!

If no condition is supplied, it will perform a cross join (resulting in a table that is the product of the rows of all input tables)

Input ports

1. Type: Table
   t1
   Table to be joined
2. Type: Table
   t2
   Table to be joined
3. Type: Table
   Port 3
   Table to be joined
4. Type: Table
   Port 4
   Table to be joined

Output ports

1. Type: Table
   Joined Output
   The resultant output table from the joining of the input tables using the supplied SQL conditions. Note that this does not use the modern ansi sql join syntax (INNER JOIN, LEFT OUTER JOIN etc), but instead uses the older syntax of simply list all the join conditions within the SQL WHERE clause.