I need to write a BaaN sql that lists certain records from tdpur045 and to associate the purchase currency rate from tcmcs008 that was effective at tdpur045.date. Not sure how to achieve this as there are multiple rates per currency - any help appreciated, thanks, Keith