Joins THREEtables:
T1
T2
T3
(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"
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
Output Ports
- 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
- No links available