Queries in two differents databases ( connections)

Hi, I need do a query in two tables of differents databases, this is possible? I can do this in java or just using SQL? Thanks, Cíntia Nogueira

Re: Queries in two differents databases ( connections)

Hi Cíntia, Derby does not have any builtin support for distributed joins--that is for running a query which mentions tables in two different databases. However, you may be able to accomplish what you need to do by using table functions, a feature that is implemented in the development trunk