[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[ale] Selecting from multiple tables



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.