Interesting SQLProblem using joins

Using Join when 2 columns in one table point to 1 column in another table

I have spent hours on this problem and no research has turned in my favour. Does anyone have any examples they can put forward for me.

I am really desperate to sort this out, and any help will be greatly appreciated.

Thanks
ShaunAre you meaning col1.value + col2.value from table1 is the equal to colx.value of table2
P