Internal join the transaction desk with the end result from Action 2, then you should have the complete data in the transaction desk with only each consumer's most current file. Without the need of that join, the sole details you would've from the acquisition desk are the day as well https://shanepwwwx.blogprodesign.com/57828414/facts-about-how-to-join-a-outlaw-motorcycle-club-revealed