Good Day All, I am currently trying to join two tables that have date columns but I need the date in table b to be one day after the date in table 1. Table A has account number, case number and a date an action occured. Table B has account number and a date a different action occured. I need the results from table A where the action in table B happened the next day. Table B can have multiple entries for each account number, but I only want the results where the action happened the next day. I have examples below. I have also tried a code but it does not work. Table A CM15 case_nbr Action_dt 1234 A1234 1/1/2015 1235 A1235 1/12/2015 1236 A1236 1/20/2015 1237 A1237 1/20/2015 1238 A1238 1/23/2015 Table B CM15 action_dt 1234 1/1/2002 1234 1/2/2015 1234 1/30/2015 1235 1/13/2015 1235 2/1/2015 1236 1/20/2015 1237 1/21/2015 1238 2/6/2015 Expected Results CM15 case_nbr action_dt 2nd_action_dt 1234 A1234 1/1/2015 1/2/2015 1235 A1235 1/12/2015 1/13/2015 1237 A1237 1/20/2015 1/21/2015
... View more