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