Hi Naomi

Thanks for the SQL but it returns many records from table B per table A record. I need the SQL to return one record B with highest effective_date less than a given date and with highest event_sequence on that date.

Your advice is much appreciated

Thanks & Best Regards