m_formigoni wrote:

>>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.
>>
>>
>
>Actually it's not what I'm looking for, I want a way to SELECT data
>from another database.
>
>I'm thinking to have a database with the "important" data and another
>containing the zip-codes wich in Brazil is very large (105MB). I'd
>like to store in separated databases to ease the backup/restore and
>due to the frequent updates in the zipcodes database.
>
>So, in my application I'll be logged to the main database and when I
>enter a zipcode I need to get the data (street, city, etc..) from the
>zipcode database, actually I want to do a select with join using
>tables from main database and zipcode database, understood?
>
>Is there a way?
>
>
>
>

Do it in your app code.

Let your app conected to the both databases.

When then user enter a zip code, just search the street, city, state
values from the second database (the zip code database) and populate you
controls that will insert data in the main database.

But, if you want to do cross database queries (joining tables from both
databases), then there is no way in the curent version of FB.

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.5/110 - Release Date: 22/09/2005