SELECT posls.posrjls,
posda.posbh,
ygda.ygbh,
posls.qdsj,
posls.qtsj,
posls.byj,
zrjehj=sum(zrje),
ysjehj=sum(ysje),
mljehj=sum(mlje),
ssjehj=sum(ssje),
pdhj=sum(fk_pd),
yqhj=sum(fk_yq),
gzhj=sum(fk_gz),
xjhj=sum(fk_xj),
cphj=sum(fk_cp),
xykhj=sum(fk_xyk),
hykhj=sum(fk_hyk),
yfkhj=sum(fk_yfk),
qthj=sum(fk_qt),
yjhj=sum(fk_yj)
FROM posls LEFT OUTER JOIN ygda ON posls.czyzj = ygda.ygzj,posda RIGHT OUTER JOIN posls ON posda.poszj = posls.poszj,yyls /*
WHERE ( yyls.jspos = posls.poszj ) and
( ( posls.jbbz = 0 ) AND
( posls.poszj = :a_poszj ) AND
( yyls.jssj >= posls.qdsj ) AND
( yyls.jsxz > 0 ) )
*/
GROUP BY posls.posrjls,
posda.posbh,
ygda.ygbh,
posls.qdsj,
posls.qtsj,
posls.byj ----------------------------------------------------------------------------------------出错提示:服务器: 消息 1013,级别 15,状态 1,行 24
表或函数 'posls' 和 'posls' 具有相同的表现名称。请用相关名称区分它们。在查询分析器中点击对勾的时候就会出现以上的错误信息。
posls as a LEFT OUTER JOIN ygda ON posls.czyzj = ygda.ygzj,posda RIGHT OUTER JOIN posls as b ON posda.poszj = posls.poszj,yyls