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.
- Type: Tablet1First table (t1) to be joined
- Type: Tablet2Second table (t2) to be joined