ACCESS的表达式中的类型不匹配

来源：百度知道编辑：UC知道时间：2024/05/04 05:04:13

我最近刚刚学会使用ACCESS，其中遇到下面问题：表达式中的类型不匹配，尝试了几次都没有成功，请教大侠
SELECT sanren.hh AS 三人卡号, sixun.hh AS 卡号, sanren.sjf AS 三人积分, sixun.jf AS 积分, sanren.smc AS 三人名称, sixun.xm AS 姓名, sixun.dhc AS 电话一, sixun.dhd AS 电话二, sixun.dhe AS 电话三
FROM sanren INNER JOIN sixun ON sanren.hh=sixun.hh;
SELECT sanren.hh AS 三人卡号,sixun.hh AS 卡号,sanren.sjf AS 三人积分,sixun.jf AS 积分,sanren.smc AS 三人名称,sixun.xm AS 姓名,sixun.dhc AS 电话一,sixun.dhd AS 电话二,sixun.dhe AS 电话三
FROM sanren,sixun INNER JOIN sixun ON sanren.hh=sixun.hh
提示了JOIN的语法错误了

SELECT sanren.hh AS 三人卡号,sixun.hh AS 卡号,sanren.sjf AS 三人积分,sixun.jf AS 积分,sanren.smc AS 三人名称,sixun.xm AS 姓名,sixun.dhc AS 电话一,sixun.dhd AS 电话二,sixun.dhe AS 电话三
FROM sanren,sixun INNER JOIN sixun ON sanren.hh=sixun.hh

你的","都是中文的输入状态的。还有"FROM"后面帮你加了",sixun"了。你试试

或者你先别加",sixun"试试看行不。这方面的有点忘记了。