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? 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 ... 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 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 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
Archived
This topic is now archived and is closed to further replies.