如何将一个表中的两列数据分割为结果表的多个列?

So I have been trying to get mySQL query to work for a large database that I have. I have (lets say) two tables Table_One and Table_Two. Table_One has three columns Type, Anima and TestID and Table_Two has 2 columns Test_Name and Test_ID. Example with values is below:So I have been trying to get mySQL query to wor