LEFT JOIN tables from two different databases

[DLR]

Is this possible with mysql 5.1?

 

I want to join a table MENU from database A to table PERMISSIONS from database B (and then if I can get this to work, extend this to further databases C, D etc).

 

I have tried creating a temporary table in database A and trying to LEFT JOIN to the table in database B - but which connection do I use? So far I have not got this to work.

 

If it is possible to join two databases, I would appreciate you pointing me to the manual section (or other reference) where I can solve the problem.

 

Many thanks.