Merging data from 3 tables into one

Hi,

I have run into a problem where i need to merge the data from 3 different table to a new one.

1st table:

i have details of certain organisations with their post codes, type of organisation etc and has about 7 columns

2nd table:

Has about 15+ columns and also has organisation names and their post codes.

3rd table:

Has rating for certain organisation,

I have to merge details from these tables to get combined list of organisation names, their ratings(if available), their post codes and type of organisation to form a new table to visualise the combined details in a map.

Current challenge: By using data models i am able to represent the details in map but are represented as a hierarchy/layers and we need to drill down to get different details.

Desired result: To represent all the details in the same layer of Map.

Can someone please help!

Thanks a lot in advance!