Re: Query Two Databases

[John Meyer]

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.