Display 3 lists in one data view (sharepoint)

Question

Hi all,

I would like to display tree different lists in one view in sharepoint.

1) Project_list: here I have all projects

2) Project_list_Costs: here I have all costs for each project (project name is the reference)

3) Project_list_Revenues: here I have all revenues for each project (project name is the reference)

One project element can have more costs/revenue elements (1:n)

Now I want to create one view with following colums:

Project_list.Projectname, Project_list.Account, SUM(Project_list_Revenues.RevenueEUR), SUM(Project_list_Costs.CostsEUR)

Does anyone know how to make it?

Thanks a lot, fiuman007