multiple 2 columns from different tables

Hi

I want to create a table that shows SalesRepName, Product they sold (drug name), Customers they sold to, The told amount sold (Unit * Price). My problem the # of Unit and Price/Unit are in different tables. I am stuck here to create a column in the visual table which show the total. Any idea would be very much appreciated. Thank you very much.