Interior join the transaction desk with the end result from Action 2, then you will have the entire documents in the transaction table with only Every single shopper's most current history. A further approach will be to implement a NOT EXISTS problem as part of your join problem to test https://born-again-soldiers-of-go43045.suomiblog.com/a-review-of-how-to-join-outlaw-motorcycle-clubs-book-52285247