Source: http://dev.mysql.com/doc/mysql/en/MERGE.html
The MERGE storage engine was introduced in MySQL 3.23.25.
I think that the MERGE table type would be an option you could use.
Instructions about how to create a merge table are on the page.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
zeus@stripped wrote on 08/30/2004 12:58:48 PM:
> 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
>
