How to join tables by range of number

[alvin85]

Hi, is there a way to do this kind of join in Clickhouse?

select * from tableA a left join tableB b on a.mynumber between b.rangefrom and b.rangeto

Thanks.