Forum Replies Created

  • terrylynch

    Member
    September 24, 2021 at 12:00 am in reply to: SQL query to Functional query[Parse Tree]

    You could use a dot amend

    dictionary:`t1`t2`t3!(([]datefield:2?0Wj);([]datefield2:2?0Wj);([]datefield3:2?0Wj)); 
    .[`dictionary;;"p"$]each((`t1;`datefield);(`t2;`datefield2);(`t3;`datefield3));

    Assumes your tables are unkeyed.