full join时，如何将两表的matchingCols合成一列

Question

在dolphindb database中，有个代码如下：

t1= table(1 2 3 3 6 as time, 1.1 2.1 3.1 3.1 6.1  as value)
t2 = table(5 3 1 as time,  5.1 3.1 1.1 as qty)
fj(t1, t2, `time)

fj后的结果如下：

time    value    t2_time    qty
1        1.1        1        1.1
2        2.1        
3        3.1        3        3.1
3        3.1        3        3.1
6        6.1        
                    5        5.1

我想得到如下结果：

time    value    qty
1        1.1        1.1
2        2.1    
3        3.1        3.1
3        3.1        3.1
5                   5.1
6        6.1    

代码应该怎么写？谢谢！

Answer 1

可以用下面代码：

select  nullFill(t1.time, t2.time) as time, value, qty from fj(t1, t2, `time) order by nullFill!(t1.time, t2.time)

或者

(select  nullFill(t1.time, t2.time) as time, value, qty from fj(t1, t2, `time)).sortBy!(`time)