I have two tables that are unable to be joined on any column. However, in table 1, I have a substring that I want to search against a column in table 2. Below is an example of both tables.

Table 1:

| Name | Substring |
| --- | --- |
| VT 2021-VASA | 2021-VASA |
| BSSTMT, 2021-SSCP | 2021-SSCP |
| LIFEMT, 2021-BMR | 2021-BMR |

Table 2:

| Name |
| --- |
| Vienna 2021-VASA Turner |
| Best Sleep Since, 2021-SSCP |
| LIFE 2021-BMR |

What I would like to accomplish is using the Substring in table 1 to find the names in Table 2 so I can match them with the Names in table 1. Ideally, I would like the results to look like this

| Tbl 1 Name | Tbl 1 Substring | Tbl 2 Match |
| --- | --- | --- |
| VT 2021-VASA | 2021-VASA | Vienna 2021-VASA Turner |
| BSSTMT, 2021-SSCP | 2021-SSCP | Best Sleep Since, 2021-SSCP |
| LIFEMT, 2021-BMR | 2021-BMR | LIFE 2021-BMR |

I'm stuck because I can't join the two tables so I really don't know where to begin.