DLR Posted August 12, 2011 Share Posted August 12, 2011 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. Quote Link to comment https://forums.phpfreaks.com/topic/244611-left-join-tables-from-two-different-databases/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.