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..
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
> __________ NOD32 1.1073 (20050420) Information __________
>
> This message was checked by NOD32 antivirus system.
> http://www.nod32.com
>
>