I have two tables, an exchange rate table, which has (edate
date, currency char(3), rate decimal(8,2)) (each record is
valid from edate) and a transactions table, which has (tdate
date, amount decimal(10,2), currency char(3)).
I would like to select the correspondent exchange rates for
all the transaction rows. Exchange rate record is valid, if
that is the latest (<=) compared to the transaction's date.
Please help me how to select it!
select transaction.tdate, transaction.amount, transaction.currency, exchange.rate .....
|• Selecting exchange rates||Bokodán Gábor||11 Sep|