I have 2 tables.
Table one [Person_Details]
Table two [Age_Range]
I want to update Age Range in table 1 from table 2, based on the Age in Days value.
There might be an easier way of doing this, and i'd be grateful for any advice. But I can't figure this out at all.
thanks
Table one [Person_Details]
Person ID | Date of Birth | Age in Days | Age Range |
KL123 | 26/07/1994 | 10254 | 26-40 |
DJ348 | 24/01/2000 | 8346 | 18-25 |
Table two [Age_Range]
Min Age Days | Max Age Days | Age Range |
0 | 6570 | <18 |
6570 | 9490 | 18-25 |
9490 | 14965 | 26-40 |
I want to update Age Range in table 1 from table 2, based on the Age in Days value.
There might be an easier way of doing this, and i'd be grateful for any advice. But I can't figure this out at all.
thanks