jaymc Posted November 25, 2007 Share Posted November 25, 2007 I want to left join a table onto a table from another database Is this possible? Quote Link to comment https://forums.phpfreaks.com/topic/78728-solved-join-from-another-database/ Share on other sites More sharing options...
Barand Posted November 25, 2007 Share Posted November 25, 2007 As long as they are on the same server ... FROM db1.table1 as t1 LEFT JOIN db2.table2 as t2 ON t1.col = t2.col ... Quote Link to comment https://forums.phpfreaks.com/topic/78728-solved-join-from-another-database/#findComment-398436 Share on other sites More sharing options...
jaymc Posted November 25, 2007 Author Share Posted November 25, 2007 I've tried.doesnt appear to be working SELECT `databasename.tablename.fieldname` FROM `databasename.tablename` Correct? Also tried this Quote Link to comment https://forums.phpfreaks.com/topic/78728-solved-join-from-another-database/#findComment-398442 Share on other sites More sharing options...
wsantos Posted November 25, 2007 Share Posted November 25, 2007 As long as they are on the same server ... FROM db1.table1 as t1 LEFT JOIN db2.table2 as t2 ON t1.col = t2.col ... Using federated tables would overcome this... and jaymc...Yes Quote Link to comment https://forums.phpfreaks.com/topic/78728-solved-join-from-another-database/#findComment-398523 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.