• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1238
  • Last Modified:

Select from two different databases

Good day

I would like to know if it is possible to select data from more then one database if I work in one connection currently.

In sql server  I think the syntax is as follows
select a
from History..Employee

How can I perform the same operaion in firebird
1 Solution
firebird does not support any kind of cross-database activity within one connection as a connection is to 1 database. You can, however, have 2 connections, 1 to each database and do the join yourself or connect to 1, run the query then connect to the other.

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now