I have an application that, for example,
creates table_name_1, table_name_2, table_name_3
then when it creates table_name_4 it deletes table_name_1.
then when it creates table_name_5 it deletes table_name_2.
and so on.. It drives me nuts, but its an application that I have no control over changing..
All tables have exact same columns.
Is this even possible.. for me to create a view that is "select * from table%" to pull the data from all the tables together in a name that doesn't change..