pl/sql developer 中,两表相减,保存结果答:或者两表连接相减:select A.* from kucun A join (SELECT "MODEL","SPEC","COLOR",SUM(FIVE) s1,sum(SIX) s2,sum(SEVEN) s3,sum(EIGHT) s4,sum(NINE) s5,sum(TEN) s6 FROM sale group by MODEL,SPEC,COLOR;) B where A.model=B.model and A.spec=B.spec and A.color = B....