Hi Christian Sorry for not making the question clear and my poor english. The table is the lookup table. I need to tabulate the location into the list by looking at the table where the customer is by using the date and time in the list. The expected answers are Customer ID Transaction date time location of customer 1…