title: Join tables from different databases in Magento
body: <p>I need to join 2 tables from 2 different databases in Magento. I tried to find answer on web but can't find anything useful. </p>
  
  <p>Also, can I execute one SQL query on different databases from one resource? </p>