如何将一个表中的多个列连接到另一个表中的列

I am quite new to SQL, most of my other questions I have been able to answer by searching but this one seemed harder to find something similar. I did see I am quite new to SQL, most of my other questio