title: Join two database table from two different databases in the same server
body: <p>Can we join two table from two different database and both databases are hosted on same servers.</p>
  
  <p>I have a database from drupal 7 and another one from codeigniter 3.0. I can connect drupal database from codeigniter and fetch the record but i want to join drupal database table with codeigniter database.
  If possible than please help me.</p>