Maybe

SELECT Ammount, Currency, ExRate FROM BIG.DB A INNER JOIN
SMALL.DB B ON A.Currency=B.Currency and B:UserType = :UserType;

or if based on individuals

SELECT Ammount, Currency, ExRate FROM BIG.DB A INNER JOIN
SMALL.DB B ON A.Currency=B.Currency and B:UserNo = :UserNo;

:UserType or :UserNo = User Dependend Variables supplied at
time of Query.

or some combination

============================

Jose Gomez wrote:

>
> Hi,
>
> I'm changing an app from BDE to IB6. I need to calculate an
> accounts-recibable aging report, on 1-30, 31-60, etc. days... The trick
> comes with the exchange rates, which each user can enter to make their
> estimates.
> Each account invoice can be in franks, dollars, pesos, etc. So the user
> enters a list of estimated exchage rates, this can be different for each
> user, sales gets some numbers, accounting others, and CEO others.
> I used to have 2 databases one locally so each user entered his/her own data
> and then make a few queries joining both databases for each user to make
> their own calculations.
> Something like:
>
> SELECT Ammount, Currency, ExRate FROM S:\SERVER\BIG.DB A INNER JOIN
> C:\LOCAL\SMALL.DB B ON A.Currency=B.Currency;
>
> How can I do this with IBO / IB?
>
> Thanx in advance.
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/