Interior join the transaction table with the end result from Stage 2, then you'll have the complete data in the transaction table with only each customer's hottest report. +----+-------------+--------------------+------------+-------+-------------------------------------------------+-------------------------------------------------+---------+-------------------------------+----------+... https://ralphs184gau4.blogolenta.com/profile