>To the select statement also add the BT dates.
>
>That select statement is exactly what you have written in your update. You wanted to update client table and you wanted to connect both tables based on date ranges.

Ok, I see now the adjustment required inside the select for the inner join.

I have adjusted it and tested it ok so far.

Thanks