Inner join the transaction desk with the outcome from Move two, then you'll have the entire records from the transaction table with only Every customer's latest report. A further method will be to use a NOT EXISTS issue in your join condition to test for later on buys: The club https://andrenzmve.alltdesign.com/the-5-second-trick-for-how-to-join-outlaw-motorcycle-clubs-55508319