Board index » delphi » SQL of two different databases

SQL of two different databases

I need a SQL statement which join tables of two different databases.
(Im working with Delphi 5, and Interbase 6)
 

Re:SQL of two different databases


I'm pretty sure you can just preceed each tablename by the database name and
a dot.

Select [alias.columns] from dbase1.Table A, dbase2.Table B where
A.ColumnName=B.ColumnName

Quote
"Desarrollo" <desarro...@helisa.com> wrote in message

news:3a03144d_1@dnews...
Quote
> I need a SQL statement which join tables of two different databases.
> (Im working with Delphi 5, and Interbase 6)

Other Threads