[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[ale] Selecting from multiple tables
- Subject: [ale] Selecting from multiple tables
- From: meuon at geeklabs.com (Mike Harrison)
- Date: Tue, 4 Oct 2005 08:50:17 -0400 (EDT)
- In-reply-to: <[email protected]>
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.