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