Yeah the naive approach would to join on key. Otherwise can join on a transaction id and key. However it's definitely complicated to get right.