The key is field Material. Table SalesBudget can have multiple rows with the same value for Material, with each a different date value in sales_price_valid_from. I want to add the fields of table SalesBudget to table Costing, where the date in sales_price_valid_from of table SalesBudget is the MOST RECENT AND BEFORE the date PostingDate of table Costing. How do I do that?