[ale] Selecting from multiple tables

[George Carless]

On Sun, Oct 02, 2005 at 10:48:33PM -0400, Mike Harrison wrote:
> > This is not a simple join where you join tables by keys.  This is where
> > I want to select all the data from many tables that are the same.  Is
> > this possible?
> 
> Probably not, but it depends more on what SQL server you are running.. 
> and what you are connecting with it with.
> 
> ie: PHP and MySQL.. No. (or at least, I'm fairly sure, no.)

Wrong - you can do joins across multiple databases running on the same 
MySQL server; e.g. select * from db1.users inner join db2.groups on 
users.group_id = groups.group_id ... 

--George