在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