[RESOLVED] join tables from two seperate databases

[LordRogaine]

I've tried finding information on this, but couldn't find anything. Is it possible to join to seperate tables from seperate databases together in a single select statement?

Thanks in advance,
Lord Rogaine

[NogDog]

I'm not aware of a way to do it directly, but I seem to recall seeing it done somewhere via the use of a temporary table - something like creating the temporary table by querying from one database, then selecting the other database and querying it with a join on the temporary table. At least that might give you something to search on?

[Roger_Ramjet]

Some database engines can do his and some can't - and those that can only do it in some versions. MySQL can not.

[LordRogaine]

thanks guys