Inner join the transaction table with the outcome from Phase 2, then you should have the complete information of your transaction table with only Each individual customer's most current history. +----+-------------+--------------------+------------+-------+-------------------------------------------------+-------------------------------------------------+---------+--------------------... https://seymourc827dox3.wikiap.com/user