Re: SQL Problem

From: Hank Robinson <cudau_at_csv.warwick.ac.uk>
Date: 28 Jul 1994 03:25:48 +0100
Message-ID: <3174vc$le1_at_crocus.csv.warwick.ac.uk>

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,
> [snip]

Er, aren't you missing some close brackets (parentheses)

   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))
                                      ^

Hank Robinson.
University of Warwick. Received on Thu Jul 28 1994 - 04:25:48 CEST