Em 19/3/2012 00:15, Helen Borrie escreveu:
At 02:19 PM 19/03/2012, Alexandre Benson Smith wrote:
You can do cross database joins using execute statement in FB 2.5.
It's true that you can perform DML in an external database from within a PSQL
module in v.2.5, using the EXECUTE STATEMENT
ABS Thanks for the clarification... I'm not using 2.5 yet, but I recall to
ABS take a look on this feature (cross database DML), Perhaps I did an SP to
ABS check on another database... I will look for the test I did.
What can be done now is a workaround to simulate a cross-db-query,
using a
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