bofh5255597

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?