Question:
I have 2 tables. One shows eligible members (active members) and table b shows dis-enrolled members
Table A:
Member # | Effective Date |
603 | 1/1/2016 |
604 | 3/14/2018 |
Table B:
Member # | Effective Date | Dis-enroll_Date |
604 | 3/14/2018 | 9/12/2018 |
The output, should be:
Member # | Effective Date | Month | Year | Disenroll_Date | Dis-enroll Month | Dis-enroll Year | Active |
603 | 1/1/2016 | Jan | 2016 |
|
|
| Yes |
604 | 3/14/2018 | March | 2018 | 9/12/2018 | September | 2018 | No |
Thanks for all your help.
Solved! Go to Solution.
Thank you!