I have two tables, each with a numeric value and a text value. I want to use the numeric value in each record in the first table to select the record in the second table whose numeric value is the largest value less than or equal to the value in the first table, and join the two records. An example might be to categorize people into age groups:
Fred 50 Fifties
Ralph 32 Thirties
Sarah 43 Forties
I don't even know what to call such a join, nor if it is possible with a query or would have to be done in SQL. Seems like this would be a fairly common problem for sorting things into groups, but I haven't been able to word an online search properly to turn up postings of similar problems.
ADDENDUM: Thank you for your responses. That was a bad example, I apologize. The second table will contain starting points for each range, but in the "real life" problem I am trying to solve, they will not all be multiples of 10, they could be any integer.