Joining MySQL and Informix tables
<p>I have a table in MySQL that I need to join with a couple of tables in a different server. The catch is that these other tables are in Informix.</p>

<p>I could make it work by selecting the content of a MySQL table and creating a temp table in Informix with the selected data, but I think in this case it would be too costly.</p>

<p>Is there an optimal way to join MySQL tables with Informix tables?</p>