Re: SUM(QUESTION)

Article View: borland.public.vdbase.data.sql

Article #1050

Back to borland.public.vdbase.data.sql Previous Next

#1050

From: Keith G. Chuvala (TeamB)
Date: Fri, 15 May 1998 00:00

15 lines
1216 bytes

> This would only get the the SUM of the Amount for the country with out
> regard for what work area it is.  

Oops, sorry I missed the work area (the 'W' in 'I.W' from your example,
correct?)  Change it to:

  select division,country,w,sum(amount) from input group by division,country,w

Now you'll have it broken down by all three.

I do hope you're not talking about *dBASE* work areas.  If so, I can't fathom
how you've got things set up....

kgc

Technical Details

Message-ID: <355C7753.1DEAE29@DELETE_THIS.hit.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References:

<6j8ia7$9br11@forums.borland.com> <3557DBDA.C21AD80@ibm.net> <6j9l9f$9vp14@forums.borland.com> <35590D45.A88DECC4@ibm.net> <35597071.447EAFE2@ibm.net> <6jcoho$d1v8@forums.borland.com> <355A0F02.8DEC8988@DELETE_THIS.hit.net> <6jfmct$evd16@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,d5546114e3a7f07c
X-Google-Attributes: gidff5a1,public
From: "Keith G. Chuvala (TeamB)" <kgc@DELETE_THIS.hit.net>
Subject: Re: SUM(QUESTION)
Date: 1998/05/15
Message-ID: <355C7753.1DEAE29@DELETE_THIS.hit.net>
X-Deja-AN: 353565148
Content-Transfer-Encoding: 7bit
References: <6j8ia7$9br11@forums.borland.com> <3557DBDA.C21AD80@ibm.net> <6j9l9f$9vp14@forums.borland.com> <35590D45.A88DECC4@ibm.net> <35597071.447EAFE2@ibm.net> <6jcoho$d1v8@forums.borland.com> <355A0F02.8DEC8988@DELETE_THIS.hit.net> <6jfmct$evd16@forums.borland.com>
Content-Type: text/plain; charset=us-ascii
Organization: First Intermark Corp.
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message