I have a large table that i need to move data to another table because it is so big. I can export the data to another table just like it but I want to run the same report and pull data from both tables.
Details:
Two tables that have the same data fields but on is for 2012 data and one is for2013 data.
I want to run a single report that will pull all the data I need from both tables at the same time.
Please let me know if you need more clarification