Not a Group By Clause

From: Jack Colletta <email_at_colletta.com>
Date: 6 Aug 2002 05:40:02 -0700
Message-ID: <7b81cff.0208060440.1353bae0_at_posting.google.com>

Please help

I have this view in Oracle 8i and I am getting "Not a Group by Expression" Error. I have included any select column that is not min/max in my group by. Help

Thanks
Jack

---

CREATE OR REPLACE VIEW "ROCKWELL"."COILTEST" ("SSHIFT",
"LOEECONFIGWORKCELLID","SWORKCELLDESCRIPTION","TSTART","TEND",
"SPARTDESCRIPTION") AS
SELECT e.sShift, e.lOEEConfigWorkcellId, cwc.sDescription, MIN(

    e.tstart), e.tEnd,

(SELECT MAX(sStartVal)

	 FROM OEEEvent 
		WHERE lOEEConfigEventId  IN (
		SELECT  lOEEConfigEventId
		FROM OEEConfigEvent 
		WHERE sDescription = 'Part Description' ) 
	 	AND tEnd = e.tEnd AND lOEEConfigWorkcellId =

e.lOEEConfigWorkcellId)                  

FROM OEEEvent e, OEEConfigWorkcell cwc, OEEConfigEvent ce

	WHERE e.lOEEConfigEventId = ce.lOEEConfigEventId 
	 AND e.lOEEConfigWorkcellId = cwc.lOEEConfigWorkcellId 
	 

GROUP BY e.sShift, e.lOEEConfigWorkcellId, cwc.sDescription, e.tEnd Received on Tue Aug 06 2002 - 14:40:02 CEST