If they are myisam tables you can use the merge storage engine.
http://dev.mysql.com/doc/mysql/en/MERGE.html
On Mon, 30 Aug 2004 09:58:48 -0700 (GMT-07:00), zeus@stripped
<zeus@stripped> wrote:
> 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!
>
> -Bob
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
>
--
Eric Bergen
eric.bergen@stripped
