大家帮看看我这个ACCESS SQL的问题

susanzhg

我写了如下的SQL查询可总是报错麻烦大家帮看看问题出在哪里先谢谢了

select qs.code,

       qs.cp_code,

       qs.sc_code,

       qs.type_code,

       qs.cn_name,

       qs.en_name,

   cp.cn_name as cp_cn_name,

   cp.en_name as cp_en_name,

   sc.cn_name as sc_cn_name,

   sc.en_name as sc_en_name

from   question as qs

inner join chapter as cp on cp.cp_code = qs.cp_code

inner join section as sc on sc.sc_code = qs.sc_code

and qs.cp_code = sc.cp_code;

附件是错误信息.

wwwwa

TRY:select qs.code,

       qs.cp_code,

       qs.sc_code,

       qs.type_code,

       qs.cn_name,

       qs.en_name,

   cp.cn_name as cp_cn_name,

   cp.en_name as cp_en_name,

   sc.cn_name as sc_cn_name,

   sc.en_name as sc_en_name

from   (question as qs

inner join chapter as cp on cp.cp_code = qs.cp_code)

inner join section as sc on sc.sc_code = qs.sc_code

徐阿鹏

不用表的别名能行吗？

susanzhg

谢谢两位的关注,按照wwwwa   的做法就搞定了谢谢.