Subject Re: Select data from another database
Author Svein Erling Tysvær
--- In, "m_formigoni" wrote:
> Hello,
> I'd like to know the way to SELECT data from another database.
> I've seen something using "[" in IBExperts but it only works for an
> insert statement like:
> Insert into [Destination_Alias].NEW_Table select * from Old_Table
> And I believe it's parsed by the IBExperts, not native.
> Is there a way to do this select?

There is no way to do this in SQL. But maybe you can do it using QLI.
Take a look at this message (and the rest of the thread):

Or maybe you're looking for replication, something that there should
be plenty of messages discussing.