如何查找表2中的数据满足表1中的数据区间，输出相关的关联结果。

1、将表1业绩字段弄成两个字段分别为：业绩下限，业绩上限。
2、写查询(大体有三种写法)：
（1）写法1--域函数:
select a.*,dlookup("绩效工资","表1","返佣职称='" & a.返佣职称 & "' and 业绩下限<=" & a.业绩 & " and 业绩上限>" & a.业绩) as 绩效工资
from 表2 as a
（2）写法2--子查询:
select a.*,(select b.绩效工资 from 表1 as b where b.返佣职称=a.返佣职称 and b.业绩下限<=a.业绩 and b.业绩上限>a.业绩) as 绩效工资
（3）写法3--联接:
select a.*,b.绩效工资
from 表2 as a inner join 表1 as b on (b.返佣职称=a.返佣职称 and b.业绩下限<=a.业绩 and b.业绩上限>a.业绩)