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:
- When using join statements that are not compatible with ANSI SQL-92, ensure the
tables to be joined have different names. For example:
select * from wj(t1, t2, -5s:0s, <avg(price) as avg>, `sym`time)
; - When joining a table or the result of a SQL query (including nested joins), you can
specify an alias for the table or SQL query result. You can also set aliases for
dimension tables when joining.
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