Join Custom Condition

Joins two tables:
t1 the TOP input table  and
t2 the BOTTOM input table

Specify the columns to be returned using the column filters.
Specify the condition, using SQL (H2 Database syntax)

e.g.
t1."name" = t2."name" or t1."name"=t2."alternative_name"

table column names are case-sensitive and will work without including the double-quotes only if the 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 both input tables, with every row in t1 joined to every row in t2.

Input ports

1. Type: Table
   t1
   First table (t1) to be joined
2. Type: Table
   t2
   Second table (t2) to be joined

Output ports

1. Type: Table
   Joined Output
   The resultant output table from the joining of table t1 with table t2.