Ora-00979 not a GROUP BY expression

来源:百度知道 编辑:UC知道 时间:2024/06/06 00:36:34
select rpbean.id rpid,
rpdbean.id rpdid,
bcbean.id bcid,
whbean.wareName,
bcbean.matname,
bcbean.matModel,
bcbean.matUnit,
bcbean.wateUniitPrice,
sum(rpdbean.passQuty) as passQuty,
sum(rpdbean.reqquty) as reqquty,
sum(bcbean.matquty) as matquty,
bcbean.lowWare
from mm_require_plandetail rpdbean
left join mm_require_plan rpbean on rpbean.id = rpdbean.planid
left join mm_base_mmcode bcbean on bcbean.id = rpdbean.mmcodeid
left join mm_base_warehouse whbean on whbean.id = bcbean.positonid
where rpbean.billState = '已终结'
and rpdbean.mmcodeid not in
(select ppd.mmcodeid
from mm_purchase_plandetail ppd
where ppd.purplanid = 2)
group by rpbean.id,
rpdbean.id,
bcbean.id,
whbean.wareName,
bcbean.matname,

帮你解决了 分给我波~

group by 的时候把
rpdbean.passQuty,
rpdbean.reqquty,
bcbean.matquty,
这三个去掉

group by
rpbean.id rpid,
rpdbean.id rpdid,
bcbean.id bcid,
whbean.wareName,
bcbean.matname,
bcbean.matModel,
bcbean.matUnit,
bcbean.wateUniitPrice,
bcbean.lowWare