Re: SQL Problem

From: Joe Halpin <jhalpin_at_netcom.com>
Date: Thu, 28 Jul 1994 10:17:04 GMT
Message-ID: <jhalpinCtnB8H.KyB_at_netcom.com>

Newsgroups: comp.databases.oracle

Subject: Re: SQL Problem
Summary: 
Expires: 

References: <316drf$24rr_at_postoffice.manassas.ibm.com> Sender:
Followup-To:
Distribution:
Organization: Netcom Online Communications Services (408-241-9760 login: guest) Keywords:

In article <316drf$24rr_at_postoffice.manassas.ibm.com> mlanda_at_vnet.ibm.com writes:
>
>Has anyone ever seen this error before? Any advice as to an alternate method
>without having to create temporary tables would be appreciated. Thanks.
>
>
>INSERT INTO ACTPROD_ALLOC_DEN
>SELECT C.SOURCE_ITEM,
> SUM((A.Q1*B.Y1*D.Y1)*((1+E.Y1Q1)/2),
> SUM((A.Q2*B.Y1*D.Y1)*((1+E.Y1Q2)/2),
> SUM((A.Q3*B.Y1*D.Y1)*((1+E.Y1Q3)/2),
> SUM((A.Q4*B.Y1*D.Y1)*((1+E.Y1Q4)/2)
>FROM THRUPUT A, ACTIVITY_DRIVERS B, ACT_PROD_METH C,
> MACHINE_HOURS D, DETAILYIELDS E,
>WHERE A.MENUPRODUCT=B.MENUPRODUCT AND
> B.MENUPRODUCT=C.MENUPRODUCT AND
> C.MENUPRODUCT=D.MENUPRODUCT AND
> D.MENUPRODUCT=E.MENUPRODUCT AND
> A.SECTOR=D.SECTOR AND
> D.SECTOR=E.SECTOR AND
> A.SECTOR=11 AND
> C.ALLOC_METH=B.DRIVER_TYPE AND
> B.DRIVER_TYPE='HR MHRS' AND <-----+
>GROUP BY C.SOURCE_ITEM; |
> |

                                         |

Is that last 'AND' supposed to be there? Looks like it's expecting something else before the GROUP BY.

Also, the parentheses at the beginning aren't balanced (in the list of SUMs).

>
> SUM((A.Q1*B.Y1*D.Y1)*((1+E.Y1Q1)/2),
> *
> error at line x:
> ORA-00935: group function is nested too deeply
>
>
>

Joe

-- 
Joe Halpin 
jhalpin_at_netcom.com
---------------------------------------------------------------------------

Received on Thu Jul 28 1994 - 12:17:04 CEST