If they are myisam tables you can use the merge storage engine.
On Mon, 30 Aug 2004 09:58:48 -0700 (GMT-07:00), zeus@stripped
> Hi there,
> I have multiple tables with identical structures, essentially current data and older
> data. I want to query them as if they were a single table. How can I do this? I would
> like to be compatible with mysql 3.23.xx. Many thanks!
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1