Subject Re: [firebird-support] What the best way to to join 2 tables accross 2 databases ?
Author Alexandre Benson Smith
Em 18/3/2012 16:59, nathanelrick escreveu:
> hello,
>
> What the best way to to join 2 tables accross 2 databases ?
>
> actually i do on the 1rt database a select First 100 ID from myTable1 where ... and in the seconde database select * from MyTable2 where ID in (<id_we_retrieve_from_the_first_select>)
>
> but the problem, the select * from MyTable2 where ID in (<id_we_retrieve_from_the_first_select>) is very slow, especially on the prepare :(
>
> is their any better way ?
>

You can do cross database joins using execute statement in FB 2.5.

Take a look on the release notes.

see you !