Re: PHP/MySQL - Splitting similar data to two tables and querying as a whole



Create a VIEW and query it when you would like to query against both
your current and archived data...

http://dev.mysql.com/doc/mysql/en/create-view.html

.