Group 2 columns from 2 different tables

'Table 1'(Product)

'Table 2'(Products)

I want to combine the 2 different columns' values from 2 different tables in order combine them for a row within a table.  Is this possible?  

Thank you for your time!