Jim, The group by is required when you are doing a sum and other columns are involved. You have to do a group by on the non-calculated columns so your resultset makes sense. You will get a sum for each unique combination of the other columns
Dennis ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jim Belisle Sent: Friday, November 07, 2008 10:03 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Calculating a persons age. So often it is the simple things that confuse. I saw the group by line in the code I was copying from and left it off. I did not realize it always had to part of the code. Thanks Jim ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Emmitt Dove Sent: Friday, November 07, 2008 9:59 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Calculating a persons age. Jim, Your use of SUM requires a GROUP BY. create temporary view SPEEDYWORK (procnum, procdesc, tottime) as + select procnum, procdesc, sum(timeout-timein) + from workinfo + where procnum = 'spdy-82' and procdesc contains '222' + group by procnum, procdesc Emmitt Dove Manager, DairyPak Business Systems Evergreen Packaging, Inc. [EMAIL PROTECTED] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [EMAIL PROTECTED] From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jim Belisle Sent: Friday, November 07, 2008 10:47 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Calculating a persons age. I am trying to create a temporary view and get an error stating "illegal select function". Can anyone look at the code below and tell me what I am doing wrong? create temporary view SPEEDYWORK (procnum, procdesc, tottime) as select procnum, procdesc, sum(timeout-timein) from workinfo where procnum = 'spdy-82' and procdesc contains '222' Jim
