如何在SQL中跨表执行范围查询

I have two tables in a MySQL database. In the first column of data in table A (A1) I have integer values. In the first and second columns of table B (B1 and B2) I also have integer values. I would like to create a query which would give me the values where A1 is within the range B1 - B2. Is this possible to do with a MySQL query?I have two tables in a MySQL database. In the f