About the use of approximately equal values for an SQL statement

There is a standard table T1, field F1, F2

Example: 100 3

200 9

300 28

 

There is a list below, T2, only one field F1,

Example: 110

180

230

Take the lowest standard value and the final result is

110 3

180 3

230 9

After thinking for a long time, I made an SQL statement:

Select CZ. f1, BZ. f2 from (select t2.f1, min (t2.f1-t1.f1) as C from T2, T1 where t2.f1> t1.f1 group by t2.f1) CZ left join T1 BZ on (CZ. f1-cz.c) = BZ. f1

Currently, the test data is correct. I don't know if it is true or not. Is there any better way?