[RBASE-L] - Re: Simple Syntax Question

[Dawn Hast]

Damon,

 

You don't need the group by.  Try this syntax:

 

SET VAR vThisCheckAdded CURRENCY

SELECT SUM(prhdr.ded14 + prhdr.ded15) INTO vThisCheckAdded FROM prhdr, employee401k WHERE prhdr.eid = employee401k.eid

-------------- Original message from "Gray, Damon" <[EMAIL PROTECTED]>: --------------

I’m getting a syntax error on the below.  I need the CURRENCY value of DED14 and DED15 to be summed and then assigned to vThisCheckAdded.  I can’t seem to wrap my mind around how to get that done.  I’ve trued multiple permutations of the query below with no luck.  It’s likely obvious and staring me in the face, but…

 

 

 

SET VARIABLE vThisCheckAdded = Select Sum(PRHDR.DED14 + PRHDR.DED15) From PRHDR, EMPLOYEE401K Where PRHDR.EID = EMPLOYEE401K.EID Group By EMPLOYEE401K.EID

 

 

                Damon J. Gray

Anvil Corporation Business Services

                   (360) 937-0770