terrylynch @terrylynch • Joined Feb 2024 • Active a year ago Remove Connection Are you sure you want to remove from your connections? Profile Forums Discussions Replies Favorites Discussions Replies Favorites 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.