SELECT CInt(CStr(a._identify ) & '1') As _identify , 其它字段列表 F ROM {表1} as a INNER JOIN {表2} as b ON {表1}.列名 = {表2}.列名