你select后边有东西吧?group by 的时候把(pnum- receivenum-qcpassnum ) 也group by 了 ---------补充--------(pnum- receivenum-qcpassnum ) 你这个是那三个列的四则运算,不能直接引用别名select p.makeno_,sum(case when p.finish_='0' then p.num_ else p.qcpassnum_ end)as pnum,sum(p.receivenum_)as receivenum,sum(p.qcpassnum_)as qcpassnum--,(sum(case when p.fi...