Can I merge table data temporarily

K

Karen

I have data (timestamped events) in a couple tables that I'd like to do some
analysis on, but across all the tables. The fields of interest are named the
same across the tables, but there's a lot of different additional information
between the tables so merging them permanently isn't practical.

Is there a shorter way than creating a table just for the analysis,
appending records from the tables, doing the analysis and then deleting the
extra table every time?
 
Top