Table joiners

Table joiners are functions that combine data from two or more tables to create a new table based on the join predicate.

Starting from version 1.30.21/2.00.9, you can specify aliases for tables when joining tables (including nested joins). For exmaple:

t1= table(1 2 3 3 as id, 7.8 4.6 5.1 0.1 as value)
t2 = table(5 3 1 as id, 300 500 800 as qty);

select * from t1 a inner join t2 b on a.id = b.id
select * from t1 as a inner join t2 as b on a.id = b.id

select * from t1 a inner join (select * from t2 where id=3) b on a.id = b.id