Office中国论坛/Access中国论坛

标题: 大家帮看看我这个ACCESS SQL的问题 [打印本页]

作者: susanzhg 时间: 2005-10-20 01:22
标题: 大家帮看看我这个ACCESS SQL的问题
我写了如下的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 时间: 2005-10-20 17:21
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

作者: 徐阿鹏 时间: 2005-10-20 18:29
不用表的别名能行吗？

作者: susanzhg 时间: 2005-10-23 01:32
谢谢两位的关注,按照wwwwa 的做法就搞定了谢谢.

欢迎光临 Office中国论坛/Access中国论坛 (http://www.office-cn.net/)