Most RecentNewestMost VotedMost ViewedCustomer status in a specific date I have to data tables: 1. Status changes of customers: 2. Orders: I wish to add a column to Orders table which presents the customer status as of each customer at its order date, as below: Thanks in advance Solved