3 Replies Latest reply on Jan 4, 2011 11:22 AM by Richard Leeke

    Data blending from two different databases, but same tables

      I have two separate databases that are basically the same (same table names) - hosts report to one of the two databases for anti-virus.


      how do I create a worksheet in which I can combine the totals of whatever table I select? For example, in a worksheet I create I add the Year as a column, selecting 2011, and then add ThreatName as a row. I then drag over the Number of Records to see the count.


      Now, I'd like to connect to the second database and add the ThreatName for that database to the worksheet and see what the combined count is for both databases.