From: Eric Bergen
Date: August 30 2004 5:07pm
Subject: Re: using two tables help
List-Archive: http://lists.mysql.com/mysql/171766
Message-Id: <11b1bd99040830100753556f9e@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

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=eric.bergen@stripped
> 
> 


-- 
Eric Bergen
eric.bergen@stripped