I am trying to join the first two tables and get the results like the third table. Any help would be appreciated.
| From | To | Option |
| 1900 | 2017 | A |
| 2018 | 2020 | B |
| 2019 | 2099 | A |
| Year | Description | Amount |
| 2015 | Book | 500.00 |
| 2018 | Shelves | 1,000.00 |
| 2017 | Equipment | 75.00 |
| 2020 | Chairs | 50.00 |
| 2021 | Desks | 65.00 |
| Year | Description | Amount | |
| 2015 | Book | 500.00 | A |
| 2018 | Shelves | 1,000.00 | B |
| 2017 | Equipment | 75.00 | A |
| 2020 | Chairs | 50.00 | A |
| 2021 | Desks | 65.00 | A |
