V
Vinnie
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,
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,