How can i join between two databases in Interbase?

Question

I have two interbase databases, and i want to make join between. Long time ago i use MS-SQL database, and there i did that.

How can i make similar in InterBase database? Thanks answer so much!

score 2 · Accepted Answer · answered Jan 18 '13 at 13:52

2

You can't do this in InterBase. InterBase does not support such heterogeneous joins in SQL.

answered Jan 18 '13 at 13:52

Craig Stuntz

125,891
12
252
273

You have to do it in your application code. Or combine the DBs. – Craig Stuntz Jan 18 '13 at 14:21

score 0 · Answer 2 · answered Jan 17 '13 at 15:15

0

Here is a reference manual for InterBase XE SQL. It says that InterBase is close to the SQL-92 standard syntax. That is, the same JOIN syntax that you used with Microsoft SQL Server should work for you here.

answered Jan 17 '13 at 15:15

David Gorsline

4,933
12
31
36

How can i join between two databases in Interbase?

2 Answers2