I too have something similar needed
I have accumulated soo much data which is required that I want to break up into yearly tables.
E.g. table2001, table2002 and table2003 etc
I can determine which table to include from a simple check but I need to work out how to join the relevant tables in a select statement
I would of expected a simple asumption by the mysql server when a select * from table2002,table2003 where ... would assume that it should append the data as long as all the fields are the same but I guessed wrong.
How do you get this to work?