Create new table based on various other data items, but all different

[Anonymous]

 --Is there a way I can create a new (virtual'?) table based on the various different datasets (already brought into my desktop file)? But each data row would source data from a different table and possible to different data requirements.

Explanation...

I have data in a range of tables structured to suit the form the data comes in, such as one might be a rate per population, another might be a count of something which I combine with population to make a rate.

The data is a range of socio-economic indicators and while evaluation of each is useful I want to bring the range of data into a single view to present it consistently to the user.

If I had the rate for each dataset in a single table then I could show the overview and highlight which rates are outliers.

How can I get those various data items into a single view?

Thanks for any help.