mysql取最接近的两个值_MySQL在最接近的匹配值上加入两个表

我有以下情况：

tableA

+-------+-------+

| id | Value |

+-------+-------+

| 1 | 1000 |

| 2 | 20 |

| 3 | 62 |

| 4 | 0 |

+-------+-------+

tableB

+-------+--------+

| Value | Lookup |

+-------+--------+

| 10 | a |

| 20 | b |

| 30 | b |

| 40 | g |

| 50 | h |

| 60 | f |

| 70 | a |

| 80 | a |

| 90 | v |

| 100 | b |

+-------+--------+

我需要返回表B中与表A中的值字段最匹配的查找.例如.

+-------+-------+--------+

| id | Value | Lookup |

+-------+-------+--------+

| 1 | 1000 | b |

| 2 | 20 | b |

| 3 | 62 | f |

| 4 | 0 | a |

+-------+-------+--------+

我该怎么做呢？