In my work, very often I come across the scenario that the service team keep their information per month in seperate tables. Some time, the same month in 2 tables, some time one table per month. As for the table structures, there are some changes as well, for some months new columns will be added etc. In all table, there is a column "ID" that contain unique number for each row.
However, most of my analysis would need data from the columns that are common to all tables.
I'm trying to find ways to write query that pull records from those multiple tables without having to actually append them into a large gigantic table.
Would appreciate if someone can shed some light for me.
Thanks,
NS3687