I have 2 tables name and match. The name and match table have columns type. The columns and data in the name table

ID| type  |
--| ----  |
 1| 1ABC  |
 2| 2DEF  |
 3| 3DEF  |
 4| 4IJK  |

The columns and data in match table is