Merging Two Completely Different Tables
Greetings, I couldn't delete this post so, I am just completely modifying it, for anyone who navigated their way back to this and is thinking, "This isn't what I was looking for". lol I have two...
Forum Discussion
Here's a sample output to reflect where I am trying to ultimately get to:
Name1 -- Before Period1 -- StartDate -- Period1 BeginDate-1 -- Amount
Name1 -- Period1 -- BeginDate -- EndDate -- Amount
Name1 -- Period2 -- BeginDate -- FinishDate -- Amount
Name2 -- Period3 -- BeginDate -- FinishDate -- Amount
Name3 -- Period7 -- BeginDate -- EndDate -- Amount
Name3 -- After Period 7 -- Period7 EndDate+1 -- FinishDate -- Amount
Again, StartDate and FinishDate are table1 dates, while BeginDate and EndDate are table2 dates.