select a.ani from table1 as a,table2 as b where substring(a.ani,1,2) = b.tele and a.money >= b.money
select a.ani from table1 a,table2 b where substring(a.ani,1,2)=b,tel and a.money>=b.money
select ani from table1 A where [money] >= (select [money] from table2 where tele = left(A.ani,2))
select a.ani from table1 a where substring(a.ani,1,2) in (select b.tel from table2 b) and a.money=b.money
select a.ani from table1 as a,table2 as b where substring(a.ani,1,2) = b.tele and a.money >= b.money select a.ani from table1 a inner join table2 b on left(a.ani,2)=b.tel where a.money>b.money
from table1 as a,table2 as b
where substring(a.ani,1,2) = b.tele
and a.money >= b.money
where substring(a.ani,1,2)=b,tel
and a.money>=b.money
where [money] >= (select [money] from table2 where tele = left(A.ani,2))
substring(a.ani,1,2) in (select b.tel from table2 b) and a.money=b.money
from table1 as a,table2 as b
where substring(a.ani,1,2) = b.tele
and a.money >= b.money
select a.ani from table1 a inner join table2 b on
left(a.ani,2)=b.tel where a.money>b.money