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)

Options

Condition
Enter the condition to join, using the table names t1 and t2 to reference the input data on port 1 (top) and port 2 (bottom)

Input Ports

Icon
Table to be joined
Icon
Table to be joined
Icon
Table to be joined
Icon
Table to be joined

Output Ports

Icon
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.

Nodes

Extensions

Links