can anyone show me a way around my problem?
i have 2 database servers, postgresql and mysql
i need to do a select query on the postgresql database and use the recordset set returned to do another select on a mysql database
something like this
select id from postgresqltable inner join mysql table
is this possibel. i able to connect using jdbc to both database but i don't know how to use the select result from the postgresql table and join them with the mysql table
any help greatly appreciated