Hi,

I have two databases with same tables. Is there a way to link/merge these to databases. Here is an example:

Database (simplified) structure:
  - ProductData (table)
    - ProductID
    - Date
    - SoldCnt

I have two databases (not 2 tables from same database) for each store (Store1 and Store2). I want to display a merged report of these stores, like:

Store1
Product   Date   SoldCnt
   1     01-Jan    75
   1     02-Jan    85
   1     03-Jan    89
   2     01-Jan    91
   3     01-Jan    80
   3     03-Jan    88

Store2
Product   Date   SoldCnt
   1     02-Jan    92
   2     03-Jan    75
   3     01-Jan    84
   3     02-Jan    94
   3     03-Jan    97

Report
     01-Jan  02-Jan  03-Jan
1      75     177      89
2      91       0      75
3     164      94     185

        | Date
--------+---------------
Product | Sum of SoldCnt

Thanks in advance.

Edited by SheliaKWood - 21 Feb 2012 at 9:04pm