Hi,

I've got two tables:

(1) Rate table -  details the rate charged from a certain date (two columns:
date and rate)
(2) Transaction table -  details transactions executed as per a certain date
(three columns: date, transaction type, volume)

I want to create a query that contains all the fields in the transaction
table and the applicable matching rate from the rate table.

Any ideas?

Thanks,