Join Tables to Create the Summary View

Hi All,

I'm trying to join three tables to present a summary view on the Rent Received, Payment to Supplier and Repair Cost for a property. I have attached a sample data and the view I'm trying to achieve here: http://ift.tt/1BDWhYz

I have suppliercode, prop code, month and year as common columns in the tables. When I join the tables, for some months the amounts do not appear and in certain cases the amount aggregate.

Thanks

Jag