Oropeza Querejeta, Alejandro wrote:
Hi, two questions: Is it possible to select data from different Databases on the same server? Is it possible to select data from different Databases on Different servers across the network?
I searched for information on how to do it, but i haven't found any.
Best Regards Alejandro
On the same server just do this:
SELECT dbname.tablename.columnname,db2name.table2name.column2name FROM dbname.tablename, db2name.table2name; (I think you get the idea)
As far as I know you can't select data across multiple servers.
Chris
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]