Joining tables from two databases!

Data Abstract
1

Hello,
I have a question about joining two tables from two databases ( on the same server), in SQL Server it works but for Firebird it doesn’t work; so my question is can I make the join between the datasets at client, and if it is possible can you provide me some infos.

2

Hello,
If you have Firebird 2.5 you can use EXECUTE STATEMENT ON EXTERNAL feature:
http://www.firebirdsql.org/refdocs/langrefupd25-psql-execstat.html#langrefupd25-psql-execstat-on-external
http://www.firebirdfaq.org/faq16/

CREATE PROCEDURE GETREMOTEEMPLOYEE
RETURNS(
  EMP_NO SMALLINT,
  FIRST_NAME VARCHAR(16) CHARACTER SET NONE COLLATE NONE)
AS
begin
  FOR EXECUTE STATEMENT 'select emp_no, first_name from employee'
  ON EXTERNAL 'localhost:C:\Program Files\Firebird\Firebird_2_5\examples\empbuild\EMPLOYEE.FDB' 
  AS USER 'sysdba' PASSWORD 'masterkey'
  INTO :emp_no, :first_name
  DO SUSPEND;
end;

select e.emp_no, e.first_name, r.emp_no, r.first_name
from employee e, GETREMOTEEMPLOYEE r
where e.emp_no = r.emp_no