Select a.id,a.name,b.desc from table a left join table b on
a.num between b.min_num and b.max_num;