From: Date: February 13 2007 2:59pm
Subject: Re: Query Two Databases
List-Archive: http://lists.mysql.com/mysql/204962
Message-Id: <45D1C435.6040901@gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Neil Tompkins wrote:
> Following on from the email below, if I run the query
> 
> SELECT * FROM database1.table, database2.table
> 
> I get the data back, but all the data is in the same row.
> 
> How can I seperate the records ?
> 
> Regards
> Neil
> 
>

Barring an upgrade, it seems your best bet would be to use a scripting
solution, such as PHP or perl, that could accomplish the same thing.