This question is asked frequently enough that ...

1. It should be in the FAQ somewhere if it isn't already (I didn't
check, so my apologies in advance if it is there)

2. It may be something for the architecture group to consider after
Vulcan is released. The Y-valve and the new Vulcan internals appear
capable of handling the problem without breaking the architecture or
introducing a large amount of extra complexity. I like the Oracle
syntax. Once the tables from the external database are linked, the
queries become straightforward:

select a.f1, b.f2
from mytable a
left join mytable@myotherdatabase
on a.key1 = b.key1

On Thu, 2005-04-21 at 11:39 +1000, Nigel Weeks wrote:
>
> That is because cross-database queries are not supported in Firebird.
>
> You'll have to do it in your front end code with your two datasets, and do
> the join yourself.
>
> Nige.
>
> > -----Original Message-----
> > From: firebird-support@yahoogroups.com
> > [mailto:firebird-support@yahoogroups.com] On Behalf Of sasidhardoc
> > Sent: Thursday, 21 April 2005 11:32 AM
> > To: firebird-support@yahoogroups.com
> > Subject: [firebird-support] SQL Syntax 2 databases
> >
> >
> >
> > I need to select fields using an SQL query spanning two
> > different data bases SELECT FIRST_DB.TABLE.FIELD1
> > FROM FIRST_DB.TABLE
> > WHERE
> > FIRST_DB.TABLE.FIELD2 = SECOND_DB.TABLE.FIELD5 But I get an
> > error? Please help..
> >
> >
> >