求Access数据库SQL语句

Question

select adotable11.*,adotable2.* from adotable1,adotable2 where adotable1.BH=adotable2.BH
adotable1.BH是自动编号，adotable2.BH是文本型，不知怎么转换。

Answer 1

是程序中的语句吗，strtointeger不行吗

Answer 2

试过了inttostr函数未定义错误

Answer 3

strSQL：='select adotable11.*,adotable2.* from adotable1,adotable2 where adotable1.BH=Cint(adotable2.BH)';

Answer 4

select adotable11.*,adotable2.* from adotable1,adotable2 where cast(adotable1.BH as varchar(20))=adotable2.BH