一个表的连接问题

Question

在DolphinDB database中，有如下2表，连接后显示如下：

t1= table(1 2 3  as id, 7.8 4.6 5.1  as value)
t2 = table(1 3 5 as id,  300 500 800 as qty)
fj(t1,t2, `id)
id    value    t2_id    qty
1    7.8        1        300
2    4.6        
3    5.1        3        500
                5        800

若我想得到下列效果，该怎么做？

id    value    qty
1    7.8        300
2    4.6    
3    5.1        500
5               800

Answer 1

select t1.id.nullFill(t2.id) as id, value, qty from fj(t1,t2, `id)