>Actually the two backends are Visual Foxpro which makes it very difficult and the sql statement we are using is to create a Datareport.

Like it was said earlier by JCF, link the tables of one of the source into the other database and use that last one (one single connection) to connect from your application.