SQL 命令未正确结束

显示全部楼层 · 2008-6-18 09:49:33

select
t1.OPR_INST_CD,
t1.ITEM_CD,
t2.ITEM_NAME,
t2.SPEC,t1.WS_CD,
t1.OPR_INST_QTY,
sum(t3.ACPT_QTY)
from T_WORK_IN_PROC_BY_ITEM t1,
M_ITEM t2,
T_OPR_RSLT t3
where t1.ITEM_CD = t2.ITEM_CD
and t3.OPR_INST_CD=t1.OPR_INST_CD
group by
t1.OPR_INST_CD
t1.ITEM_CD
t2.ITEM_NAME
t2.SPEC
t1.WS_CD
t1.OPR_INST_QTY
提示:SQL 命令未正确结束
按1楼的做结果是一样的!

千问 · 2008-6-18 09:49:33

group byt1.OPR_INST_CDt1.ITEM_CDt2.ITEM_NAMEt2.SPECt1.WS_CDt1.OPR_INST_QTY 错了，字段间要加 , 号改成select t1.OPR_INST_CD,t1.ITEM_CD,t2.ITEM_NAME,t2.SPEC,t1.WS_CD,t1.OPR_INST_QTY,sum(t3.ACPT_QTY)from T_WORK_IN_PROC_BY_ITEM t1,M_ITEM t2,T_OPR_RSLT t3where t1.ITEM_CD = t2.ITEM_CDand t3.OPR_INST_CD=t1.OPR_INST_CD