I want to see data in the database by combining the two?
But somehow I could not.
How can I do this with the following command.
Here is the command does not work.(ON EXTERNAL DATA SOURCE)

Can you help me please?


http://www.firebirdfaq.org/faq16

FOR EXECUTE STATEMENT 'select DATA,CODE,PRICES from PRICES'
ON EXTERNAL DATA SOURCE 'd:\MYDATA2012.FDB' AS USER 'sysdba' PASSWORD 'masterkey'



There are two database.
1.Database d:\MYDATA2012.FDB
table NAME:PRICES
DATE CODE PRICE
12.10.2012 02 45
16.11.2012 03 25
17.12.2012 02 41
18.12.2012 02 40

2.Database d:\MYDATA2013.FDB
table NAME:PRICES
DATE CODE PRICE
09.10.2013 02 45
10.11.2013 03 25
24.12.2013 02 41
17.12.2013 02 40






http://www.firebirdfaq.org/faq16

Can I do multi-database or cross-database queries with Firebird?