[ale] Selecting from multiple tables

Mike Harrison meuon at geeklabs.com
Tue Oct 4 08:50:17 EDT 2005


Mike:
> > ie: PHP and MySQL.. No. (or at least, I'm fairly sure, no.)
George: 
> 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 ... 

Well I have to admit, I (re?)learned something. It works from the MySQL 
prompt, as 'root/admin', but not from my own PHP codebase as the user that 
I was using to play with normally reads specific tables only because of 
database/table/user permissions. Duh. 




More information about the Ale mailing list