Re: [firebird-support] What the best way to to join 2 tables accross 2 databases ?

2012-03-19 Thread Alexandre Benson Smith
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

Re: [firebird-support] What the best way to to join 2 tables accross 2 databases ?

2012-03-19 Thread Carlos H. Cantu
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

Re: [firebird-support] What the best way to to join 2 tables accross 2 databases ?

2012-03-18 Thread 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