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 !