请问dolphindb有类似union join的功能么?x uj y,如果匹配,则用y更新,否则用y插入
t1= table(1 2 3 3 as id, 7.8 4.6 5.1 0.1 as qty);t2 = table(5 3 1 as id, 300 500 800 as qty); select iif(isNull(t1.id), t2.id, t1.id) as id, iif(!isNull(t2.qty), t2.qty, t1.qty) from t1 full join t2 on t1.id=t2.id
上述代码可以实现