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