t1= table(1 2 3 3 as id, 7.8 4.6 5.1 0.1 as value);t2 = table(5 3 1 as id, 300 500 800 as qty);select nullFill(id,t2.id) as id,value,qty from fj(t1, t2, `id)
