SQL连接具有一系列值（int范围，日期范围，等等）

I have two tables, the first is a big table (millions of rows), with the most interesting column being an integer I'll just call "key." I believe this solution would be identical for date or datetime ranges as well though.I have two tables, the first is a big table (mi