I have 2 sets of data from two table , i need to join the table

table\_ 1

```
id     qid     choice               
--------------------------
11     2020     Item 1
12     2020     Item 2
13     2020     Item 14

```

table\_2

```
rid    qid     question
---------------------------
1001   2020    1.I love apple
1002   2020    2.I love orange
1003   2020    14.I hate lemon

```

Output 

```
id    rid     qid     choice       question
-------------------------------------------------
11    1001    2020    Item 1      1.I love apple
12    1002    2020    Item 2      2.I love orange
13    1003    2020    Item 14     14.I hate lemon

```

The formate of the column "question" in table\_2 must start with

```
1.XXXX , 2.XXXX , 14.XXXX until 20.XXXXXX

```

I think get the number before "." as the joining condition. But how to get the number or any other better solutions?