cross checking between 2 tables
i have 2 tables: 1. Operation X - which presents all dates and customers who did a specific operation - a simple customers dates dimension table (customer can be presented more than once with different dates) 2. Messages Delivered - which presents all messages delivered to all customers. i wish to check for the customers in table1 for the range of 2 days prior to the date of its operation whether there is a message delivered in that range and return its message ID & channel sample is attached. thanks, Amit
