SQL仅加入最后一个历史行

I'm sitting at the following problem: I'm writing a view where I join several tables to a person table. And I now trying to join the partners table but I only need the historical last valid partner row:I'm sitting at the following problem: I'm writi