我有个表1 表2

表1有字段 ID, SN, A, B,C,D

表2有字段  SN, E, F,G

我想查询表2中SN等于表1中SN, G >10 <100的类容, 显示 SN, A,B,E,F

SQL="Select a.a,a.b,b.e,b.f from 表1 as a, 表2 as b where a.sn = b.sn and b.g between 10 and 100 "