I have 3 tables with sales information from 3 different stores. Every table look exactly the same with the structure:

2012-01-01, Sales, KPI1, KPI2, KPI3

2012-01-02, Sales, KPI1, KPI2, KPI3

2012-01-03, Sales, KPI1, KPI2, KPI3

I want to be able to join the numbers into one report and be able to compare the numbers. 

Q1 Possible to add them up in one querytable or report?

Q2 Possible to join them and see them in the same chart separately.

thanks

Henrik