Sorry, but I got it right,
you can do this in the command line of mysql:
Code: Select all
select field1, field2 from database1.table1, database2.table2;
and will return the result. as if it where 2 tables in the same database.
PHP can't do this because the query function wants a database-connection wich has selected one database. So PHPmyAdmin can't do this either...