Combining 2 tables both have duplicate values, need help!

       Here is my simplified problem: both the Cost table and the Order table have duplicate values. I want to combine these two into one table, which shows all the values like the Desire result tabl...