使用codeigniter中的连接从多个数据库中获取数据

I am using CI to fetch data from multiple database using join and i have also created multiple instances of database. I get the result but only the one instance which I mentioned while fetching data I am using joins with multiple instances. but not able to fetch of all records of all tables. can I fetch the data from multiple database from different servers with using joins while using CI