> Svein is correct. InterBase doesn't support cross-database joins.

Hi Helen, Svein, Geoff,

Thanks for your responses. :-)

Embedded SQL Guide Chapter 3 "Working with Databases" subtitle
"Differentiating table names" on page 49 shows the syntax and an example of
a cross-database correlated subquery (this may not be the correct term as
I'm no SQL expert), so I assumed Interbase did support cross-database joins
too. I guess I was wrong.

I'm possibly going to use a table from a third-party database and some
tables from my own database. Ability to run select statements joining the
tables and some kind of referential integrity would be nice. What's the best
strategy? I could use some kind of replication to be able to work with my
database only but I'm not sure if this is the best way. Any ideas greatly
appreciated.

Cheers,
TOndrej