I have a scenario where i should get VAL from table B by joining A and B with the max date of the filled field, e.g:

A:

```
F1  F2  F3
--  --  --
1   2   t1
2   3   t2

```

B:

```
F1    F2    VAL  date
----  ----  ---  ----------
1     NULL  v10  12/30/2020
1     NULL  v11  01/31/2020
NULL  2     v20  02/28/2020
NULL  2     v22  03/30/2020

```

Desired result:

```
1  2  t1  v11  01/31/2020
2  3  t2  v22  03/30/2020

```

Thank you in advance.