Re: Not a Group By Clause

No you did not:
(SELECT MAX(sStartVal)
FROM OEEEvent
WHERE lOEEConfigEventId IN (
SELECT lOEEConfigEventId
FROM OEEConfigEvent
WHERE sDescription = 'Part Description' ) AND tEnd = e.tEnd AND lOEEConfigWorkcellId = e.lOEEConfigWorkcellId)

is actually yet another column not in group by clause of the outer select. And no matter what

"Jack Colletta" <email_at_colletta.com> wrote in message news: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:59:33 CEST