--- In firebird-support@yahoogroups.com, "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):

http://groups.yahoo.com/group/firebird-support/message/60332

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

HTH,
Set